Re: dataguard - monitoring, startup

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_at_gmail.com> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l