9 Replies Latest reply: Sep 19, 2012 7:25 AM by 933651 RSS

    data guard forum

    933651
      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
          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
            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
              kuljeet singh -
              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
                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
                  kuljeet singh -
                  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
                    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
                      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
                        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
                          Setting a fake log_file_name convert on the standby, might cause any error or any issue on the primary?