0 Replies Latest reply: Nov 18, 2013 7:54 PM by petra-K RSS

    DG Check for Log apply error

      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