Oracle 11G Physical Standby Database Active Data Guard Switchover & Failover

来源：互联网发布：windows bea 000402 编辑：程序博客网时间：2024/05/16 01:58

Data guard的正常切换为switchover，非正常的切换为failover。
1,Phyiscal standby database之active data guard switchover
主库:DGDB
备库:DGDBST
参考官方: http://docs.oracle.com/cd/E11882_01/server.112/e41134/role_management.htm#SBYDB00620

switchover之前的检查DGDB> SELECT SWITCHOVER_STATUS FROM V$DATABASE;SWITCHOVER_STATUS--------------------TO STANDBYDGDBST> SELECT SWITCHOVER_STATUS FROM V$DATABASE;SWITCHOVER_STATUS--------------------NOT ALLOWED

切换步骤DGDB> SELECT SWITCHOVER_STATUS FROM V$DATABASE;DGDBST> SELECT SWITCHOVER_STATUS FROM V$DATABASE;DGDB> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;DGDB> shutdown abort;DGDB> startup mount;DGDBST> SELECT SWITCHOVER_STATUS FROM V$DATABASE;DGDBST> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;DGDBST> ALTER DATABASE OPEN;DGDB> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

2,Phyiscal standby database之active data guard failover