Re: Data Guard Logical and monitoring

From: Bill Zakrzewski <bill_at_intactus.com>
Date: Wed, 11 May 2011 09:58:28 -0400
Message-Id: <CED7F91C-415A-4727-A6D7-C4EF476E762D_at_intactus.com>

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?

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

Received on Wed May 11 2011 - 08:58:28 CDT