Wednesday, February 22, 2012

Switch over from Primary to Standby in Oracle 11 G RAC

From Primary DB
SQL> select THREAD#, max(SEQUENCE#) from v$archived_log group by THREAD#;

THREAD# MAX(SEQUENCE#)
---------- --------------
1 724
2 252

From Standby DB
SQL> select THREAD#, max(SEQUENCE#) from v$archived_log where APPLIED='YES' group by THREAD#;

THREAD# MAX(SEQUENCE#)
---------- --------------
1 724
2 251


Primary and Standby archivelog sequences should be same , other wise we have to manual copy them or resync

From Primary DB

DGMGRL> switchover to primay_db_name
Performing switchover NOW, please wait...
New primary database "standby_db" is opening...
Operation requires shutdown of instance "primay_db_name" on database "primay_db_name"
Shutting down instance "primay_db"...
ORA-01031: insufficient privileges

Warning: You are no longer connected to ORACLE.

Please complete the following steps to finish switchover:
shut down instance "primay_db_name" of database "primay_db_name"
start up and mount instance "primay_db_name" of database "primay_db_name"

DGMGRL>

From Primary DB
[oracle@primay_db_server ~]$ srvctl stop database -d primay_db_name
[oracle@primay_db_server ~]$ srvctl start database -d primay_db_name -o mount


[oracle@standby_db_server ~]$ dgmgrl /
DGMGRL for Linux: Version 11.2.0.2.0 - 64bit Production

Copyright (c) 2000, 2009, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL> show configuration

Configuration - standby_db

Protection Mode: MaxPerformance
Databases:
standby_db - Primary database
iprimary_db - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

No comments: