Re: Data Guard Logical and monitoring

You can run the following query (right from the oracle manual) on your logical 
standby.  As the logs backup the number of rows will increase, based on your 
system you can set a threshold to be alerted.

set numformat 999999999999999
SELECT FILE_NAME, SEQUENCE# AS SEQ#, FIRST_CHANGE# AS FCHANGE#,
                NEXT_CHANGE# AS NCHANGE#, TIMESTAMP,
                DICT_BEGIN AS BEG, DICT_END AS END,
                THREAD# AS THR# 
FROM DBA_LOGSTDBY_LOG       
ORDER BY SEQUENCE#
/

HTH
Bill


On May 10, 2011, at 6:02 PM, P D wrote:

> 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?  

Other related posts: