oracle 11g dg 检查,Oracle 11g DG 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