Oracle 11g dataguard check real time apply （on standby）

环境：oracle 11.2.0.1 rac on redhat 5.8

总结方法：

1 、select open_mode from v$database;

READ ONLY WITH APPLY    -- 证明开启 RTA

2 、select DEST_ID,DEST_NAME,RECOVERY_MODE from v$archive_dest_status ;

    RECOVERY_MODE 为 MANAGED REAL TIME APPLY – 证明开启了 RTA

未开启real time apply

SQL> select open_mode from v$database;

OPEN_MODE

--------------------

READ ONLY

开启real time apply

    物理DG开启RTA命令如下：

alter database recover managed standby database using current logfile disconnect;

SQL> select process,client_process,status,thread#,sequence#,block#,blocks from v$managed_standby ;

PROCESS    CLIENT_P STATUS           THREAD#   SEQUENCE#      BLOCK#      BLOCKS

--------- -------- ------------ ---------- ---------- ---------- ----------

ARCH       ARCH      CLOSING                2          33       57344        1023

ARCH       ARCH      CLOSING                1          35           1           1

ARCH       ARCH      CONNECTED              0           0           0           0

ARCH       ARCH      CLOSING                1          34           1           1

RFS        N/A       IDLE                   0           0           0           0

RFS        LGWR      IDLE                   2          34        4987           1

MRP0       N/A       APPLYING_LOG           1          37          26      102400

RFS        UNKNOWN   IDLE                   0           0           0           0

RFS        UNKNOWN   IDLE                   0           0           0           0

RFS        N/A       IDLE                   0           0           0           0

RFS        LGWR      IDLE                   1          37          27           1

PROCESS    CLIENT_P STATUS           THREAD#   SEQUENCE#      BLOCK#      BLOCKS

--------- -------- ------------ ---------- ---------- ---------- ----------

RFS        UNKNOWN   IDLE                   0           0           0           0

--redo apply 情况

SQL> select open_mode from v$database ;

OPEN_MODE

--------------------

READ ONLY WITH APPLY

SQL> select DEST_ID,DEST_NAME,RECOVERY_MODE from v$archive_dest_status ;

   DEST_ID DEST_NAME             RECOVERY_MODE

---------- -------------------- -----------------------

         1 LOG_ARCHIVE_DEST_1    MANAGED REAL TIME APPLY

         2 LOG_ARCHIVE_DEST_2    IDLE

         3 LOG_ARCHIVE_DEST_3    IDLE

         4 LOG_ARCHIVE_DEST_4    IDLE

         5 LOG_ARCHIVE_DEST_5    IDLE

         6 LOG_ARCHIVE_DEST_6    IDLE

         7 LOG_ARCHIVE_DEST_7    IDLE

         8 LOG_ARCHIVE_DEST_8    IDLE

         9 LOG_ARCHIVE_DEST_9    IDLE

        10 LOG_ARCHIVE_DEST_10   IDLE

        11 LOG_ARCHIVE_DEST_11   IDLE

   DEST_ID DEST_NAME             RECOVERY_MODE

---------- -------------------- -----------------------

        12 LOG_ARCHIVE_DEST_12   IDLE

        13 LOG_ARCHIVE_DEST_13   IDLE

        14 LOG_ARCHIVE_DEST_14   IDLE

         15 LOG_ARCHIVE_DEST_15   IDLE

        16 LOG_ARCHIVE_DEST_16   IDLE

        17 LOG_ARCHIVE_DEST_17   IDLE

        18 LOG_ARCHIVE_DEST_18   IDLE

        19 LOG_ARCHIVE_DEST_19   IDLE

        20 LOG_ARCHIVE_DEST_20   IDLE

        21 LOG_ARCHIVE_DEST_21   IDLE

        22 LOG_ARCHIVE_DEST_22   IDLE

   DEST_ID DEST_NAME             RECOVERY_MODE

---------- -------------------- -----------------------

        23 LOG_ARCHIVE_DEST_23   IDLE

        24 LOG_ARCHIVE_DEST_24   IDLE

        25 LOG_ARCHIVE_DEST_25   IDLE

        26 LOG_ARCHIVE_DEST_26   IDLE

        27 LOG_ARCHIVE_DEST_27   IDLE

        28 LOG_ARCHIVE_DEST_28   IDLE

        29 LOG_ARCHIVE_DEST_29   IDLE

        30 LOG_ARCHIVE_DEST_30   IDLE

        31 LOG_ARCHIVE_DEST_31   IDLE

        32 STANDBY_ARCHIVE_DEST IDLE

红色部分证明standby database 开启了real time apply