RE: dataguard - monitoring, startup
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <eglewis71@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 16 Sep 2009 11:35:52 -0400
Ed,
I've found this to be very helpful is finding out where the standby
database is with regards to it's recovery:
SELECT max(decode(PROCESS, 'MRP0',
sequence#))-max(decode(process,'RFS',decode(CLIENT_PROCESS,'LGWR',
SEQUENCE#),NULL))current_log_gap
FROM V$MANAGED_STANDBY;
select process, sequence#, status from v$managed_standby
where sequence# is not null
and sequence# > 0
order by 2;
Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of ed lewis
Sent: Wednesday, September 16, 2009 10:30 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: dataguard - monitoring, startup
Hello,
I have a few questions regarding dataguard.
We currently have DG running in a 2 node cluster,
and a third server (non-rac)
The primary, and physical standby run in the cluster.
The LSB being on a separate server. (not in the cluster)
We are looking for ways to monitor the DG
environment. We're creating some scripts to do so.
Does anyone have any scripts they would recommend ?
Is grid control a viable solution ?
Also, on system reboots of the cluster, how do you handle
the startup of DG, specially on the physical and logical servers ?
Do you modify the cluster scripts, or dbstart to accommodate this,
or create something else ? I was unable to find anything on
metalink.
Your response is appreciated.
ed
solaris 5.10
oracle 10.2.0.4 ee
asm 10.2.0.4 ee
2 member rac cluster ee
Other related posts:
