DGbroker主备切换

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"

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

转载于:https://www.cnblogs.com/vijayfly/p/5065074.html