This discussion is archived
5 Replies Latest reply: Dec 7, 2012 4:04 AM by Osama_Mustafa RSS

Problems While Performing Switchover Oracle 11g

940673 Newbie
Currently Being Moderated
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

Legend

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