Re: Measure database availability beyond 99.9%
Date: Fri, 29 Aug 2008 20:03:31 +0100
Aaaarrrrgh! I'm sure there's a purpose that isn't lying to justify expensive investments. I just cannot see it. Real HA must do service level monitoring (aka can the users work) what you seem to propose has no clear benefit, please tell me I'm wrong.
On 28/08/2008, Ingrid Voigt <GiantPanda_at_gmx.net> wrote:
> we are looking for a tool to measure and report the availability of our
> databases in the HA range, i.e. with high precision. At this time we are
> only interested in the database state, not whether the customers can work.
> The database versions involved are 9.2 - 10.2, 11 coming next year. All
> editions: SE1, SE and EE.
> So far, we have been using EM Grid Control, but beyond 99,9% this is not
> precise enough. Too many failures of the agent/the Grid Control system
> rather than the database and too much time between "database back up"
> and "agent notices that database is back up". A switch in the failsafe
> clusters takes less than a minute and should be reported to the second,
> if possible.
> We can get startup time easily from a database trigger or the alertlog,
> but have not good way to measure shutdown time so far. Is there
> something good available (free would be nice) or do we have to build it
> Thanks for your help.
> Ingrid Voigt
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 29 2008 - 14:03:31 CDT