Redolog status
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Redolog status

  1. #1
    Join Date
    May 2002
    Posts
    163

    Redolog status

    Hi All,

    If I will loose one of the log members in a group - when my Datbase is up and running, does oracle write that information in ALTER file?

    I mean, without shutting down my database and bouncing it back or withour querying status in v$logfile , is there any way to know that members got deleted.

    Thanks
    Nwcomer
    Student

  2. #2
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    133

    Re: Redolog status

    Your database will crash.
    Originally posted by newcomer
    Hi All,

    If I will loose one of the log members in a group - when my Datbase is up and running, does oracle write that information in ALTER file?

    I mean, without shutting down my database and bouncing it back or withour querying status in v$logfile , is there any way to know that members got deleted.

    Thanks
    Yes, it will write a trace file in which you can see the missing and also in the alert log something like this including trace file:
    ORA-27037: Message 27037 not found; No message file for product=RDBMS, facility=ORA
    SVR4 Error: 2: No such file or directory
    Additional information: 3
    LGWR: terminating instance due to error 313
    Instance terminated by LGWR, pid = nnnnn

    HTH
    Giani

  3. #3
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    133
    Sorry I missed this part :

    eg:
    Errors in file /dbs/app/oracle/admin/$ORACLE_SID/bdump/xxxx_nnnn.trc:
    ORA-00313: Message 313 not found; No message file for product=RDBMS, facility=ORA; arguments: [4] [1]
    ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [4] [1]
    [/u01/oradata/$ORACLE_SID/redoSID_4.log
    Giani

  4. #4
    Join Date
    Jan 2003
    Location
    Bahrain
    Posts
    109

    Re: Re: Redolog status

    Originally posted by Giani
    Your database will crash.
    Hi,

    If ur database contains atleast one valid member in all the log groups, then your database won't get crash.

    But ofcourse it will write the infomation about ur invaid member in the alert files as follows

    Alert file Output
    *****************

    Dump file G:\Oracle\admin\fatma\bdump\fatmaALRT.LOG

    11:30 AM 4/29/1999Thu Apr 29 11:34:56 1999
    Thread 1 advanced to log sequence 152
    Current log# 1 seq# 152 mem# 0: G:\ORACLE\ORADATA\FATMA\REDO01.LOG
    Thu Apr 29 11:34:56 1999
    ARC0: Beginning to archive log# 2 seq# 151
    Thu Apr 29 11:35:00 1999
    Errors in file G:\Oracle\admin\fatma\bdump\fatmaLGWR.TRC:
    ORA-00313: open failed for members of log group 3 of thread 1
    ORA-00312: online log 3 thread 1: 'G:\ORACLE\ORADATA\FATMA\REDO31.LOG'
    ORA-27048: skgfifi: file header information is invalid
    OSD-04004: invalid file header

    Thu Apr 29 11:35:00 1999
    Errors in file G:\Oracle\admin\fatma\bdump\fatmaLGWR.TRC:
    ORA-00321: log 3 of thread 1, cannot update log file header
    ORA-00312: online log 3 thread 1: 'G:\ORACLE\ORADATA\FATMA\REDO31.LOG'

    Thu Apr 29 11:35:00 1999
    Errors in file G:\Oracle\admin\fatma\bdump\fatmaLGWR.TRC:
    ORA-00313: open failed for members of log group 3 of thread 1

    Trace file Output
    *************************


    *** SESSION ID:(3.1) 1999-04-29 11:24:47.477
    ORA-00313: open failed for members of log group 3 of thread 1
    ORA-00313: open failed for members of log group 3 of thread 1
    ORA-00312: online log 3 thread 1: 'G:\ORACLE\ORADATA\FATMA\REDO31.LOG'
    ORA-27048: skgfifi: file header information is invalid
    OSD-04004: invalid file header
    ORA-00321: log 3 of thread 1, cannot update log file header
    ORA-00312: online log 3 thread 1: 'G:\ORACLE\ORADATA\FATMA\REDO31.LOG'
    ORA-00313: open failed for members of log group 3 of thread 1

    Seelan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width