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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment