Re: Data Guard Logical and monitoring
- From: Bill Zakrzewski <bill@xxxxxxxxxxxx>
- To: pdba1966@xxxxxxxxxxx
- Date: Wed, 11 May 2011 09:58:28 -0400
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:
