Re: data guard fast start failover

From: Alex Gorbachev <ag_at_oracloid.com>
Date: Mon, 19 Jan 2009 22:33:42 +1100
Message-Id: <027F4E5A-F9E9-4CE4-884F-69BC99ADB51C_at_oracloid.com>



Laimutis,

As Ian explained, if your current primary looses connectivity to both Observer and standby, it *must* shutdown to avoid situation with two primary databases active and diverging. Indeed, if Observer and Standby are loosing connectivity to the primary (that is OK and operational otherwise) then Observer and standby will make decision to promote standby database to the primary role - the primary database has failed for them. Observer and standby couldn't distinguish network connectivity issue on primary from any primary host failure, power outage or whatever else.

Having data integrity above all, primary must be stopped to avoid split-brain - i.e. both databases in primary role. What you call dangerous must be relatively routine failover assuming DR is designed and implemented properly and can actually be promoted to primary safely and hold the traffic.

Cheers,
Alex

On 19/01/2009, at 6:40 PM, Laimutis.Nedzinskas_at_seb.lt wrote:

> In my case primary killed itself because it lost communication with
> BOTH
> observer and standby. Then primary thinks that since FSF is enabled
> then
> observer and/or standby would attempt to failover.
> It has a sense but it's kind of dangerous.



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


  • application/pkcs7-signature attachment: smime.p7s
Received on Mon Jan 19 2009 - 05:33:42 CST

Original text of this message