we use ZABBIX to monitor our database with custom scripts. when the lag is 15 mins or more i get a SMS and email.
data-guard.sh ------------------- #!/bin/sh . /home/oracle/.profile_db01 cd /home/oracle/zabbix sqlplus -s /nolog @check_log.sql check_log.sql ------------------ connect / as sysdba set pagesize 0; set heading off; set feedback off set trimspool on; select to_char(max(next_time), 'rrrr-mm-dd-hh24:mi:ss') next_time from v$archived_log where upper(applied) = 'YES' and registrar = 'RFS'; exit; -- Hope this Helps Mir On 10/5/2010 8:09 AM, Howard Latham wrote:
Anyone point me in the right direction for an 11g Linux Script to monitor Dataguard lag? I have googled and looked on oracle Support. -- Howard A. Latham Sent from my Nokia N97!DSPAM:2052,4cab240948768356213163!
-- //www.freelists.org/webpage/oracle-l