RE: Physical Standby Montoring
- From: "Uzzell, Stephan" <SUzzell@xxxxxxxxxx>
- To: 'Bill Zakrzewski' <bill@xxxxxxxxxxxx>
- Date: Tue, 20 Sep 2011 19:12:52 +0000
Bill,
We are not currently using GC for this. I will look into it. If anyone knows
offhand of a good by-example setup, that would be nice to have - otherwise I'll
trial and error my way through it ;-)
We don't have 100% faith in GC so we tend to use a secondary monitoring system
where possible. So any other suggestions would also be welcomed.
Stephan Uzzell
-----Original Message-----
From: Bill Zakrzewski [mailto:bill@xxxxxxxxxxxx]
Sent: Tuesday, 20 September, 2011 14:01
To: Uzzell, Stephan
Cc: Oracle L
Subject: Re: Physical Standby Montoring
Oracle Grid Control????
On Sep 20, 2011, at 1:51 PM, Uzzell, Stephan wrote:
> Hey Listers,
> Any cool tricks for monitoring a bunch of physical standby environments? We
> have 20 or so physical standby databases, and are having trouble figuring the
> best strategy to monitor them. We do not currently have enough DBAs to sit
> around watching them.
>
> We are currently using two scheduled tasks to grab the current_scn from
> v$database, alternating every 45 minutes or so; we then parse the two output
> files using perl, do some quick math, and as long as there is a change in the
> SCN, we feel things are probably OK.
>
> The problem is that the SCN does not advance at a regular interval. Some
> database are busier than others. Some database therefore do not have the SCN
> advance between a pair of tests; other times one of the scheduled tasks
> hangs. So we get periodic "BAD" reports that are not really bad.
>
> Definitely not the best system. Any recommendations for the best way to
> monitor - to only get alerts if / when there is actually something wrong?
>
> Thanks!
>
> Stephan Uzzell
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
