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
> 
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 
> 
> 

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

Other related posts: