1.檢查DG是否正常
DGMGRL> show configuration;
Configuration - dgc
Protection Mode: MaxProtection
Databases:
atest1 - Primary database
atest2 - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
2.如果DG無異常,則可以開始進行切換
DGMGRL> switchover to atest1;
Performing switchover NOW, please wait...
Operation requires a connection to instance "atest" on database "atest1"
Connecting to instance "atest"...
Connected.
Operation requires startup of instance "atest" on database "atest2"
Starting instance "atest"...
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Database mounted.
Database opened.
Operation requires shutdown of instance "atest" on database "atest1"
Shutting down instance "atest"...
Unable to connect to database
ORA-12545: Connect failed because target host or object does not exist
Failed.
Warning: You are no longer connected to ORACLE.
Please complete the following steps to finish switchover:
shut down instance "atest" of database "atest1"
start up instance "atest" of database "atest1"
如提示,需要對數據庫信息手動的啟動或者重啟