1.检查DG是否正常
DGMGRL> show configuration;Configuration - dgc Protection Mode: MaxProtection Databases: atest1 - Primary database atest2 - Physical standby databaseFast-Start Failover: DISABLEDConfiguration 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 instanceORACLE instance started.Database mounted.Database opened.Operation requires shutdown of instance "atest" on database "atest1"Shutting down instance "atest"...Unable to connect to databaseORA-12545: Connect failed because target host or object does not existFailed.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"
如提示,需要对数据库信息手动的启动或者重启
原标题:DGbroker主备切换
关键词: