Dataguard-physical Standby Failover Switching process

1.failover Pre-check

#如果有多个standby数据库 to see which standby received the latest redo. Sql> select * from V$archive_dest_status; #查看standby库接收到的最新的SCNSQL > select Thread#,sequence#,last_change#,last_ Time from V$standby_log;   thread#  sequence# last_change# last_time----------------------------------------------         1       7128    126385274 2 May-April -16         1          0            0         1          0            0sql>

2. Executive failover

#停止MRP (Close active application) sql> ALTER DATABASE recover managed standby database cancel; #重启启动MRP, complete Redo application (manual application). If there is a gap,finish will fail. At the end of execution, the protection mode becomes the maximum performance sql> ALTER DATABASE recover managed standby database finish; Sql> ALTER DATABASE commit to switchover to primary with session shutdown; sql> ALTER DATABASE open;

Dataguard-physical Standby Failover Switching process