RAC+DG正常切换

客户在两台exadata上分别创建RAC，再做DG。正常切换测试：

1.关闭辅助实例

主库：[grid@dm02db01 ~]$ srvctl stop instance -d DDCPRD -i DDCPRD2
备库：[grid@dm01db01 ~]$ srvctl stop instance -d DDCPRD_STANDBY -i DDCPRD2

2.查看状态

主库：
SQL> select switchover_status,database_role from gv$database; 

SWITCHOVER_STATUS    DATABASE_ROLE
-------------------- ----------------
TO STANDBY           PRIMARY
备库：
SQL> select switchover_status,database_role from gv$database; 

SWITCHOVER_STATUS    DATABASE_ROLE
-------------------- ----------------
NOT ALLOWED          PHYSICAL STANDBY

3.切换

<pre name="code" class="sql">主库：alter database commit to switchover to physical standby with session shutdown; #执行完主库关闭
备库：
SQL> select switchover_status,database_role from gv$database;
SWITCHOVER_STATUS    DATABASE_ROLE
-------------------- ----------------
TO PRIMARY           PHYSICAL STANDBY
SQL> alter database commit to switchover to primary;                                #执行完备库mount

4.打开库

新备库：[grid@dm02db01 ~]$ srvctl start database -d DDCPRD
新主库：实例1：SQL> alter database open;
启动实例2：[grid@dm01db01 ~]$ srvctl start instance -d DDCPRD_STANDBY -i DDCPRD2

5.查看切换结果

<pre name="code" class="sql">新主库：
SQL> select switchover_status,database_role from gv$database; 

SWITCHOVER_STATUS    DATABASE_ROLE
-------------------- ----------------
SESSIONS ACTIVE      PRIMARY
TO STANDBY           PRIMARY
新备库： 
SQL> select switchover_status,database_role from gv$database;

SWITCHOVER_STATUS    DATABASE_ROLE
-------------------- ----------------
RECOVERY NEEDED      PHYSICAL STANDBY
RECOVERY NEEDED      PHYSICAL STANDBY
SQL> alter database recover managed standby database using current logfile disconnect;#开启实时应用
SQL> select switchover_status,database_role from gv$database;

SWITCHOVER_STATUS    DATABASE_ROLE
-------------------- ----------------
NOT ALLOWED          PHYSICAL STANDBY
NOT ALLOWED          PHYSICAL STANDBY

6.切日志，看一下日志应用情况

SQL> select thread#,applied,sequence# from (select t.*,row_number()over(partition by thread# order by sequence# desc) seq from v$archived_log t) where seq<11;
主库结果：
   THREAD# APPLIED    SEQUENCE#
---------- --------- ----------
         1 NO                57
         1 YES               57
         1 NO                56
         1 YES               56
         1 NO                55
         1 YES               55
         1 NO                54
         1 YES               54
         1 YES               53
         1 NO                53
         2 NO                63
         2 NO                63
         2 YES               62
         2 NO                62
         2 NO                61
         2 YES               61
         2 YES               60
         2 NO                60
         2 NO                59
         2 YES               59
备库结果：
   THREAD# APPLIED    SEQUENCE#
---------- --------- ----------
         1 YES               57
         1 YES               56
         1 YES               55
         1 YES               54
         1 YES               53
         1 YES               52
         1 YES               51
         1 YES               50
         1 YES               49
         1 YES               48
         2 IN-MEMORY         63
         2 YES               62
         2 YES               61
         2 YES               60
         2 YES               59
         2 YES               58
         2 YES               57
         2 YES               56
         2 YES               55
         2 YES               55

切回来按以上步骤再做一次即可。