2 Replies Latest reply: Nov 26, 2013 10:09 AM by TSharma-Oracle RSS

    Dataguard Post Switchover issue

    $phinx19


      Hi All,

       

      OS:AIX

      DB:11.2.0.3

      I have just performed the switcover from my primary to standby database. The switchover was smooth but the archives are not getting shipped and applied on the new DR. I have checked the process and found that the RFS process is not up. Upon further checking I have found that the alert of my new DR is giving me this line

      Resetting standby activation ID 0 (0x0)

       

      Please let me know what does this indicates

       

      Regards

        • 1. Re: Dataguard Post Switchover issue
          TSharma-Oracle

          The message Resetting standby activation ID 0 (0x0)" is a normal message after switchover. It hard to think about a problem with so little details. Check this metalink note, this might help. There was also a similar kind of bug but in 10.2.0.4

           

          11.2 Data Guard Physical Standby Switchover Best Practices using SQL*Plus (Doc ID 1304939.1)



          There was also a similar kind of bug but in 10.2.0.4.  Workaround is to reboot the database. You can try rebooting the database. It might fix the issue.

          Bug 5476236 - RFS logminer client inoperative after physical standby switchover to primary (Doc ID 5476236.8)


           



          • 2. Re: Dataguard Post Switchover issue
            mseberg

            Hello;

             

            This should be confirming the End-of-Redo on the standby.  The 0 is in all of mine regardless of age of system ( changed MS )

             

            Was able to find the exact same message on my test standby

             

            Resetting standby activation ID 0 (0x0)

            Media Recovery End-Of-Redo indicator encountered

            Media Recovery Continuing

             

            All my Standby's have it

             

            Does not appear to be an issue.

             

            Some more details here:

             

            http://davidalejomarcos.wordpress.com/category/standby/

             

             

            Best Regards

             

            mseberg

             

            Message was edited by: mseberg