This discussion is archived
0 Replies Latest reply: Nov 18, 2013 5:54 PM by petra-K RSS

DG Check for Log apply error

petra-K Expert
Currently Being Moderated

Hi all,

 

11.2.0.1

 

We have DG physical standby by setup.

I monitor it daily by running this script at the PRIMARY and STANDBY.

 

SELECT PROCESS, CLIENT_PROCESS, SEQUENCE#, STATUS FROM V$MANAGED_STANDBY;

 

Sample output from PRIMARY:

 

SQL> select client_dbid, process, sequence#, status from v$managed_standby;

 

 

CLIENT_DBID                              PROCESS    SEQUENCE# STATUS

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

2488076743                               ARCH             696 CLOSING

2488076743                               ARCH             523 CLOSING

2488076743                               ARCH             697 CLOSING

2488076743                               ARCH             698 CLOSING

2488076743                               LNS              699 WRITING

 

 

 

Sample output from STANDBY:

PROCESS   CLIENT_P  SEQUENCE# STATUS

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

ARCH      ARCH            697 CLOSING

ARCH      ARCH            698 CLOSING

ARCH      ARCH              0 CONNECTED

ARCH      ARCH            696 CLOSING

MRP0      N/A             699 WAIT_FOR_LOG

RFS       UNKNOWN           0 IDLE

RFS       LGWR            699 IDLE

RFS       UNKNOWN           0 IDLE

 

 

8 rows selected.

 

 

The process is considered running good if at primary it is currently writing on log 699 , while at the standby is it waiting for log 699.

How can I create a script for this such that it will show  if there is error, or gaps, or anything abnormal behavior in my DG process?

Can you share me your monitoring scripts please.

 

Thanks,

 

Petra-K

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points