DataGuard的监控

1. 观察Data Guard的进程状态

在Standby上

点击(此处)折叠或打开

1. SELECT PROCESS, CLIENT_PROCESS,THREAD#, SEQUENCE#,STATUS
   
2. FROM V$MANAGED_STANDBY;

PROCESS  CLIENT_PROCESS      THREAD#  SEQUENCE# STATUS
-------- ---------------- ---------- ---------- --------------------
ARCH     ARCH                      1        120 CLOSING
ARCH     ARCH                      1        119 CLOSING
ARCH     ARCH                      0          0 CONNECTED
ARCH     ARCH                      1        121 CLOSING
RFS      UNKNOWN                   0          0 IDLE
RFS      LGWR                      1        122 IDLE
RFS      UNKNOWN                   0          0 IDLE
MRP0     N/A                       1        122 APPLYING_LOG

2. 查询尚未应用的变更：

点击(此处)折叠或打开

1. SELECT * FROM V$DATAGUARD_STATS;

NAME                             VALUE                                                            UNIT                           TIME_COMPUTED                  DATUM_TIME                   
-------------------------------- ---------------------------------------------------------------- ------------------------------ --------------------
transport lag                    +00 00:00:09                                                     day(2) to second(0) interval   12/22/2014 16:40:42            12/22/2014 16:40:02            
apply lag                        +00 00:00:09                                                     day(2) to second(0) interval   12/22/2014 16:40:42            12/22/2014 16:40:02            
apply finish time                +00 00:00:01.024                                                 day(2) to second(3) interval   12/22/2014 16:40:42                                           
estimated startup time           30                                                               second                         12/22/2014 16:40:42                                           

详细解释：
Name of the metric:

• APPLY FINISH TIME - An estimate of the time needed to apply all received, but unapplied redo from the primary database. If there are one or more redo gaps on the standby database, an estimate of the time needed to apply all received, but unapplied redo up to the end of the last archived redo log before the beginning of the earliest redo gap.

• APPLY LAG - Apply lag is a measure of the degree to which the data in a standby database lags behind the data in the primary database, due to delays in propagating and applying redo to the standby database. This value is relevent only to the applying instance.

• TRANSPORT LAG - Transport lag is a measure of the degree to which the transport of redo to the standby database lags behind the generation of redo on the primary database. If there are one or more redo gaps on the standby database, the transport lag is calculated as if no redo has been received after the beginning of the earliest redo gap.

• ESTIMATED STARTUP TIME - An estimate of the time needed to start and open the database.

---

查询重做速率

---

查看恢复进度

点击(此处)折叠或打开

1. select to_char(start_time, 'DD-MON-RR HH24:MI:SS') start_time,
   
2.      item, round(sofar/1024,2) "MB/Sec"
   
3.      from v$recovery_progress
   
4.      where (item='Active Apply Rate' or item='Average Apply Rate');

START_TIME           ITEM                               MB/Sec      TOTAL
-------------------- ------------------------------ ---------- ----------
22-DEC-14 15:18:31   Active Apply Rate                    5.22          0
22-DEC-14 15:18:31   Average Apply Rate                    .17          0
22-DEC-14 11:28:48   Active Apply Rate                     .73        750
22-DEC-14 11:28:48   Average Apply Rate                    .17        170

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22621861/viewspace-1376380/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22621861/viewspace-1376380/