Oracle 11g dataguard check real time apply

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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26442936/viewspace-768474/，如需轉載，請註明出處，否則將追究法律責任。