Re: Best practice for Dataguard in 10g?

From: Nuno Souto <>
Date: Sun, 06 Sep 2009 19:42:23 +1000
Message-ID: <>

Ahbaid Gaffoor wrote,on my timestamp of 6/09/2009 7:13 PM:

> I've used it for (hit a few bugs), with a few patches
> was stable, and I've been running it on a few systems.

Thanks. We're in - 11g will be the next step up, so it's a no-no for us at the moment: had my fair share of 10g bugs, don't need anymore! :)

> system failover to another in under 40 seconds (that's my worst case,
> best case was 10 secs) on a hevily used prod system, without any manual
> intervention was incredible.

Yes, but you see: incredible and other such wow-factors are very low in our list of priorities. ;)

> Even if you did the steps manually, you
> can't beat it. I was able to get a db failoved over to another
> datacenter in a power loss event in 35 seconds using FSFO..

The good thing is time to failover is immaterial to us. This is a DW, not a OLTP system: the failover taking seconds or minutes is really not an issue at all. What I don't want is for it to kick in because of a glitch in the network, somewhere else. There are a number of feeds into and out of the DW, worldwide, that would be seriously affected by spurious triggering.

> so I'd recommend it from upwards

Cool. Thanks heaps for that info.

> I still have to dig into the FSFO specific 11g enhancements, but I do
> know you can control failover programatically now.

Indeed. Just finished the 11g Dataguard admin course and we did a few as part of the labs. Very nice and I like the concept of the application itself being able to initiate failover - opens up a lot of possibilities, not necessarily related to network connectivity or db availability.

Nuno Souto
in sunny Sydney, Australia
Received on Sun Sep 06 2009 - 04:42:23 CDT

Original text of this message