Re: dataguard - monitoring, startup
Date: Wed, 16 Sep 2009 10:12:58 -0700
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
arch.thread# = appl.thread#
order by 1;
On Wed, Sep 16, 2009 at 7:29 AM, ed lewis <eglewis71_at_gmail.com> wrote:
> 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
> Your response is appreciated.
> solaris 5.10
> oracle 10.2.0.4 ee
> asm 10.2.0.4 ee
> 2 member rac cluster ee