你的位置:首页 > 数据库

[数据库]DGbroker主备切换


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"

如提示,需要对数据库信息手动的启动或者重启