Oracle 11g dataguard check real time apply - Oracle-fans - 博客园

SYS(139_22)@fpyj123>  select open_mode from v$database;

OPEN_MODE

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

READ ONLY

SYS(139_22)@fpyj123>  select process,client_process,status,thread#,sequence#,block#,blocks from v$managed_standby;

PROCESS   CLIENT_P STATUS          THREAD#  SEQUENCE#     BLOCK#     BLOCKS

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

ARCH      ARCH     CONNECTED             0          0          0          0

ARCH      ARCH     CONNECTED             0          0          0          0

ARCH      ARCH     CONNECTED             0          0          0          0

ARCH      ARCH     CLOSING               1         63          1        421

RFS       N/A      IDLE                  0          0          0          0

RFS       LGWR     IDLE                  1         64        123          1

RFS       UNKNOWN  IDLE                  0          0          0          0

--没有MRP0 进程哦，不能RTA

开启real time apply

物理DG开启RTA命令如下：

SYS(139_22)@fpyj123> alter database recover managed standby database using current logfile disconnect from session;         

Database altered.

再次检查MRP进程

SYS(139_22)@fpyj123> select process,client_process,status,thread#,sequence#,block#,blocks from v$managed_standby;

PROCESS   CLIENT_P STATUS          THREAD#  SEQUENCE#     BLOCK#     BLOCKS

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

ARCH      ARCH     CONNECTED             0          0          0          0

ARCH      ARCH     CONNECTED             0          0          0          0

ARCH      ARCH     CONNECTED             0          0          0          0

ARCH      ARCH     CLOSING               1         63          1        421

RFS       N/A      IDLE                  0          0          0          0

RFS       LGWR     IDLE                  1         64        221          1

RFS       UNKNOWN  IDLE                  0          0          0          0

MRP0      N/A      APPLYING_LOG          1         64        221     102400

--redo apply情况  

SQL> select open_mode from v$database;

OPEN_MODE

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

READ ONLY WITH APPLY

SYS(139_22)@fpyj123> col DEST_NAME for a20

SYS(139_22)@fpyj123> set linesize 1000

SYS(139_22)@fpyj123> set pagesize 1000

 col dest_name for a20

SQL> select DEST_ID,DEST_NAME,RECOVERY_MODE from v$archive_dest_status where recovery_mode not like 'IDLE' ;

   DEST_ID DEST_NAME            RECOVERY_MODE

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

         1 LOG_ARCHIVE_DEST_1   MANAGED REAL TIME APPLY

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