Re: Dataguard Monitoring
- From: "Mir M. Mirhashimali" <mhyder@xxxxxxxx>
- To: howard.latham@xxxxxxxxx
- Date: Tue, 05 Oct 2010 11:45:51 -0500
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!
--
http://www.freelists.org/webpage/oracle-l
Other related posts: