5 Replies Latest reply: Dec 7, 2012 6:04 AM by Osama_Mustafa RSS

    Problems While Performing Switchover Oracle 11g

    940673
      Hi All,

      I am using Oracle 11.2.0.1.0 version.

      I have a Primary-Physical Standby setup(Test Environment). I am performing a switchover between them.

      I have followed the below steps:-

      ON Primary:-

      SQL> select switchover_status from v$database;

      SWITCHOVER_STATUS
      ------------------------------------------------------------
      TO STANDBY

      SQL> alter database commit to switchover to physical standby;

      Database altered.

      SQL> shutdown immediate;
      ORA-01507: database not mounted


      ORACLE instance shut down.
      SQL> startup mount;
      ORACLE instance started.

      Total System Global Area 2054373376 bytes
      Fixed Size 2214856 bytes
      Variable Size 1174406200 bytes
      Database Buffers 872415232 bytes
      Redo Buffers 5337088 bytes
      Database mounted.
      SQL> select switchover_status from v$database;

      SWITCHOVER_STATUS
      ------------------------------------------------------------
      TO PRIMARY

      SQL> select database_role from v$database;

      DATABASE_ROLE
      ------------------------------------------------
      PHYSICAL STANDBY

      On the other side I am trying to bring up the phyical standby database to primary:-

      First I checked the switchover_status on standby database.

      SQL> select switchover_status from v$database;

      SWITCHOVER_STATUS
      ------------------------------------------------------------
      SWITCHOVER PENDING

      SQL> alter database commit to switchover to primary;
      alter database commit to switchover to primary
      *
      ERROR at line 1:
      ORA-16139: media recovery required


      Now I am in a situation where I have converted my primary to physical standby but physical standby-Primary is not happening..

      Please advice me on this. I have checked the archive log status for both the boxes before switchover and they were in sync....

      Your suggestions are required here.

      Regards,
      Arijit