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

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 STANDBY

DGDBST> 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