Re: dataguard - monitoring, startup
- From: Sanjeev Mellacheruvu <sanjeevorcle@xxxxxxxxx>
- To: eglewis71@xxxxxxxxx
- Date: Wed, 16 Sep 2009 10:12:58 -0700
Ed,
I use following query modified based on metalink note 861595.1 to add few
columns for thread#:
select arch.thread# "Thread",
appl.first_time "LastSeqApp1sttime",appl.sequence# "Last Sequence Applied",
arch.first_time "LastSeqRec1sttime",arch.sequence# "Last Sequence
Received",
(arch.sequence# - appl.sequence#) "DiffSeq",
round((arch.first_time-appl.first_time)*1440) "DiffMins"
from
(select thread# ,sequence#,first_time from v$archived_log where
(thread#,first_time ) in (select thread#,max(first_time) from v$archived_log
group by thread#)) arch,
(select thread# ,sequence#,first_time from v$log_history where
(thread#,first_time ) in (select thread#,max(first_time) from v$log_history
group by thread#)) appl
where
arch.thread# = appl.thread#
order by 1;
Regards,
Sanjeev.
On Wed, Sep 16, 2009 at 7:29 AM, ed lewis <eglewis71@xxxxxxxxx> wrote:
> 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:
