This discussion is archived
9 Replies Latest reply: Sep 19, 2012 5:25 AM by 933651 RSS

data guard forum

933651 Newbie
Currently Being Moderated
Hello everybody !

Yesterday I noticed that my standby server was behind the prduction one.
In the error log I noticed:
ORA-00600: internal error code, arguments: [kcbr_apply_change_11], [], [], [], [], [], [], [], [], [], [], []

then
MRP0: Background Media Recovery terminated with error 448
Recovered data files to a consistent state at change 286116915

This error happens in sequence: Recovery of Online Redo Log: Thread 1 Group 4 Seq 8830 Reading mem 0

I found this archive log in standby and it is same size as in the production one.

Anybody can help me please?
  • 1. Re: data guard forum
    CKPT Guru
    Currently Being Moderated
    930648 wrote:
    Hello everybody !

    Yesterday I noticed that my standby server was behind the prduction one.
    In the error log I noticed:
    ORA-00600: internal error code, arguments: [kcbr_apply_change_11], [], [], [], [], [], [], [], [], [], [], []

    then
    MRP0: Background Media Recovery terminated with error 448
    Recovered data files to a consistent state at change 286116915

    This error happens in sequence: Recovery of Online Redo Log: Thread 1 Group 4 Seq 8830 Reading mem 0

    I found this archive log in standby and it is same size as in the production one.

    Anybody can help me please?
    What is the version?
    You have to use Error lookup tool to investigate Internal errors. *ORA-600/ORA-7445/ORA-700 Error Look-up Tool [ID 153788.1]*
    Version of database is very important, you can take a look this note +Managed Recovery fails with ORA-00600:[kcbr_apply_change_11] [ID 1318733.1]+
    Can you perform clean shutdown and start with recovery your standby database Again, If any errors from alert log file during startup, Please post here.

    >
    930648      
         Newbie
         
    Handle:      930648
    Status Level:      Newbie
    Registered:      Apr 27, 2012
    Total Posts:      39
    Total Questions:      14 (11 unresolved)
    >

    Close your old threads and keep the forum clean.

    Thank you

    Edited by: CKPT on Sep 19, 2012 12:11 PM
  • 2. Re: data guard forum
    933651 Newbie
    Currently Being Moderated
    oracle 11g installed on Red Hat Linux
    When I start the standby database in managed recovery I see no error from sql plus.
    In the log.xml I can see the errors above.
  • 3. Re: data guard forum
    KuljeetPalSingh Guru
    Currently Being Moderated
    Appear Bug !
    check metalink (MOS) note on this
    Managed Recovery fails with ORA-00600:[kcbr_apply_change_11] [ID 1318733.1]
  • 4. Re: data guard forum
    933651 Newbie
    Currently Being Moderated
    Maybe I am wrong, but 2 days ago we made a shutdown abort to the production database.
    Could it have damaged sth?
  • 5. Re: data guard forum
    KuljeetPalSingh Guru
    Currently Being Moderated
    Could it have damaged sth?
    it should not,but if you check the MOS note above,you will get detail on this error message
  • 6. Re: data guard forum
    mseberg Guru
    Currently Being Moderated
    Hello;

    Clear your SRL's
    alter database recover managed standby database cancel;
    
    SQL> select 'alter database clear logfile group '|| group# ||';' from v$standby_log;
    You probably did nothing to cause this.

    Best Regards

    mseberg
  • 7. Re: data guard forum
    933651 Newbie
    Currently Being Moderated
    I just did this : but I get error:

    SQL> alter database clear logfile group 4;

    Database altered.

    SQL> alter database clear logfile group 5;

    Database altered.

    SQL> alter database clear logfile group 6;

    Database altered.

    SQL> alter database clear logfile group 7;
    alter database clear logfile group 7
    *
    ERROR at line 1:
    ORA-19527: physical standby redo log must be renamed
    ORA-00312: online log 7 thread 0:
    '/u01/aaa/bbb/database/AWredo/standby_redo04.log'
  • 8. Re: data guard forum
    mseberg Guru
    Currently Being Moderated
    Got it.

    That is covered by this note :

    ORA-600 [KCVADC.7] AND [KCCOCX_01] during recovery [ID 1321667.1]

    I think its bug 8677584

    Best Regards

    mseberg
  • 9. Re: data guard forum
    933651 Newbie
    Currently Being Moderated
    Setting a fake log_file_name convert on the standby, might cause any error or any issue on the primary?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points