Re: Data Guard (zero data loss)

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Fri, 07 Mar 2003 20:24:27 +1100
Message-Id: <pan.2003.03.07.09.24.27.673249@yahoo.com.au>

On Fri, 07 Mar 2003 17:11:42 +0800, Timmy Sin wrote:

> Does anyone have experience on the zero data loss feature with Data Guard
> 9i? It states that modification would be committed only when the redo
> information has been at least transferred to one of the standby databases.
> Is this feature practical in real life? How about if the primary and standby
> databases are connected by a T1 WAN link?

If you were a financial institution that could afford precisely zero data loss, then this would be a very practical solution to a critical problem... and you would invest a bazillion dollars to make sure that the link (a) could cope and (b) didn't fail and thus cause problems on your primary site.

Is it practical for mom-n-pop operations, or anyone whose primary link to the standby site was no better than the T1 link you describe? Doubtful.

Regards
HJR Received on Fri Mar 07 2003 - 03:24:27 CST