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?