3 Replies Latest reply: May 3, 2011 7:53 AM by sanikv RSS

    ORA-00279

    user522961
      Hi,
      on 10g R2 on HP unix , in standby alertlog I have :
      ORA-279 signalled during: ALTER DATABASE RECOVER  standby database until change 1106544632 PARALLEL (DEGREE 6)  ...
      Tue May  3 10:02:41 2011
      ALTER DATABASE RECOVER    CONTINUE DEFAULT
      And in documentation :
      ORA-00279: change string generated at string needed for thread string
      Cause: The requested log is required to proceed with recovery.
      Action: Please supply the requested log with "ALTER DATABASE RECOVER LOGFILE <file_name>" or cancel recovery with "ALTER DATABASE RECOVER CANCEL".

      Then if it can not find log file why it CONTINUES DEFAULT ?

      What is standby doing ? And why nothing in alertlog since 10:02 ?

      Thank you.
        • 1. Re: ORA-00279
          Helios-GunesEROL
          Hi;

          Please see below which could be helpful for your issue:
          Synchronization of primary and standby database due to log transfer gap. [ID 150214.1]
          Data Guard Wizard: Create Standby Failed Ora-279 [ID 381536.1]

          Regard
          Helios
          • 2. Re: ORA-00279
            user522961
            thank you.

            Can you pleas tell me what do mean the lines with RFS[n] ? Is it applying archived logs ?
            ORA-279 signalled during: ALTER DATABASE RECOVER  standby database until change 1106544632 PARALLEL (DEGREE 6)  ...
            Mon May  2 20:45:37 2011
            ALTER DATABASE RECOVER    CONTINUE DEFAULT
            Mon May  2 20:45:37 2011
            Media Recovery Log /data01/oracle/MYDB/arch01/arc_MYDB_1_92074_703274790.arc
            Mon May  2 20:45:37 2011
            Incomplete Recovery applied until change 1106557331
            Mon May  2 20:45:37 2011
            Media Recovery Complete (MYDB)
            Completed: ALTER DATABASE RECOVER    CONTINUE DEFAULT
            Mon May  2 20:45:43 2011
            RFS[19]: Archived Log: '/data01/oracle/MYDB/arch01/arc_MYDB_1_92136_703274790.arc'
            Mon May  2 20:45:51 2011
            RFS[15]: Archived Log: '/data01/oracle/MYDB/arch01/arc_MYDB_1_92137_703274790.arc'
            Mon May  2 20:45:58 2011
            • 3. Re: ORA-00279
              sanikv
              its not applying logs now, the messages that start with RFS indicates that you are receiving logs from primary.

              you will need to start recovery on standby as follows:

              recover managed standby database until current logfile disconnect;