ADG或者DG的切换步骤:
1. 可以切换的情况,主库查询
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
--------------------
TO STANDBY
2.如果主库是上面的状态,将主库切换至备用模式
SQL> alter database commit to switchover to physical standby with session shutdown;
3.关闭、装载主数据库
SQL> shutdown immediate;
SQL> startup mount;
或者
SQL> startup;
4.查看备库准备向主库模式切换
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
————————
TO PRIMARY
1 row selected
注:如果是TO PRIMARY表示可以正常切换,不过还会遇到NOT ALLOWED和PENDING或者LATENT,实际操作下来如果备库的switchover_status为not allowed或者to primary都可以正常切换
5.切换备库至主库模式
SQL> alter database commit to switchover to primary with session shutdown;
6.打开新的主数据库
SQL> ALTER DATABASE OPEN;
7. 在新的备库服务器上启动 REDO apply。
SQL> alter database open;
SQL> alter database recover managed standby database using current logfile disconnect from session;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22039464/viewspace-1754222/,如需转载,请注明出处,否则将追究法律责任。