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

最新推荐文章于 2025-11-13 18:25:23 发布

原创最新推荐文章于 2025-11-13 18:25:23 发布 · 1k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

Oracle Data Guard 专栏收录该内容

13 篇文章

订阅专栏

本文详细介绍了Oracle数据库中Dataguard的两种切换方式：switchover与failover。通过具体步骤展示了如何从主库切换到备库，并提供了实际操作的SQL命令示例。

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