cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Standby/DataGuard Alert

Description

This alert will monitor the delta between Oracle redo logs that are archived on the primary instance and those that are applied on the standby instance.

Note: Additional grants may be required on the monitored instances if the monitoring user cannot query from v$archived_log.

This describes how to set this up as a custom alert, but the same SQL can be used to define a custom metric (see Oracle custom metrics section).

SQL Statement:

select (

SELECT MAX(SEQUENCE#) LOG_ARCHIVED

FROM V$ARCHIVED_LOG

WHERE DEST_ID=1

AND ARCHIVED='YES'

) - (

SELECT MAX(SEQUENCE#) LOG_APPLIED

FROM V$ARCHIVED_LOG

WHERE DEST_ID=2

AND APPLIED='YES'

) from dual;

pastedImage_3.png

pastedImage_2.png

Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎04-21-2015 11:52 AM
Updated by: