RE: Dataguard Monitoring
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <hdeng@xxxxxxxxxxxxxxxx>, <mhyder@xxxxxxxx>, <howard.latham@xxxxxxxxx>
- Date: Wed, 6 Oct 2010 10:58:16 -0400
My favorite is:
select process, client_process, sequence#, status from v$managed_standby
where sequence# is not null
and sequence# > 0
order by 3;
It produces the following:
PROCESS CLIENT_P SEQUENCE# STATUS
--------- -------- ---------- ------------
RFS ARCH 0 IDLE
RFS ARCH 0 IDLE
ARCH ARCH 35482 CLOSING
ARCH ARCH 35494 CLOSING
RFS LGWR 35495 IDLE
MRP0 N/A 35495 APPLYING_LOG
And since RFS and MRP0 are both on the same log, your just fine. If the
status is "Waiting on Log" then you've got a problem.
Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Flora Deng
Sent: Wednesday, October 06, 2010 10:25 AM
To: mhyder@xxxxxxxx; howard.latham@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Dataguard Monitoring
If you're using real time apply and just want to check if DG is out of
sync,
here is a quick SQL:
Suppose 'dest_id=2' is your standby and any rows returned will mean
standby
is out of sync.
select thread#,max(sequence#) from v\$archived_log
where dest_id=2 and applied='YES'
group by thread#
minus
select thread#,max(sequence#) from v\$archived_log
where dest_id=2 and archived='YES'
group by thread#;
Flora
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Mir M. Mirhashimali
Sent: Tuesday, October 05, 2010 11:46 AM
To: howard.latham@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Dataguard Monitoring
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
