RE: Data Guard Logical and monitoring

I run the following scripts and check the results. If this script returns ORA-16128 then the standby process is down. select status
  from dba_logstdby_events
where event_time =

(select max(event_time)

             from dba_logstdby_events);
exit

If the result of this script > 0, the the standby process is lagging behind. This may be normal if we are applying lots of changes.

select newest_scn-applied_scn from dba_logstdby_progress; exit

This report just shows how far behind the standby process is.

set lines 132
column newest_scn format 99999999999999 column applied_scn format 99999999999999 column status format a60
select newest_scn,applied_scn
  from dba_logstdby_progress;
select status,to_char(event_time,'mm/dd/yyyy hh24:mi:ss') event_time   from dba_logstdby_events
where event_time =

(select max(event_time)

             from dba_logstdby_events);
exit

Hope these help.

Tom

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of P D Sent: Tuesday, May 10, 2011 6:02 PM
To: oracle-l_at_freelists.org
Subject: Data Guard Logical and monitoring

Does anybody have a script or a method for monitoring Data Guard Logical so that you get notified if the archivelogs are not being applied to the standby and are just continuing to increase in number? This is for a 10.2.0.4 database on AIX.

Are there any other things that you monitor and how?

--
http://www.freelists.org/webpage/oracle-l