ITPub博客

首页 > 数据库 > Oracle > Oracle 11g dataguard check real time apply

Oracle 11g dataguard check real time apply

原创 Oracle 作者:lovehewenyu 时间:2013-08-14 13:36:51 0 删除 编辑

Oracle 11g dataguard check real time apply on standby


环境:oracle 11.2.0.1 rac on redhat 5.8

总结方法:

1select open_mode from v$database;

READ ONLY WITH APPLY   --证明开启 RTA

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

    RECOVERY_MODEMANAGED 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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle,Mysql,EMC 存储,NBU备份

注册时间:2012-02-03

  • 博文量
    267
  • 访问量
    1295827