DG故障切换

故障切换测试也是必不可少的。此次故障测试如下：

1.关闭辅助实例

<span style="font-size:12px;">[grid@dm01db01]$ srvctl stop instance -d DDCPRD_STANDBY -i DDCPRD2</span>

2.取消MRP(Managed Recovery Process），应用所有的重做数据

<span style="font-size:12px;">alter database recover managed standby database cancel;
alter database recover managed standby database finish;</span>

3.切换后，重启数据库

<pre name="code" class="sql">SQL> alter database commit to switchover to primary with session shutdown;
SQL> alter database open;
SQL> select open_mode,switchover_status,database_role from v$database;

 OPEN_MODE            SWITCHOVER_STAT