Re: Data Guard (zero data loss)

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Sun, 9 Mar 2003 20:06:21 -0000
Message-ID: <3e6bb9a2$1_1@mk-nntp-1.news.uk.worldonline.com>

"Timmy Sin" <tswsin_at_yahoo.com> wrote in message news:b49nof$dg3$1_at_news.hk.linkage.net...
> Hi All,
>
> 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?
>
> Thanks,
> Timmy
>

Surely this requires no more than common sense? The technical mechanism is irrelevant; if one is going to guarantee no data loss, then there has to be a successful save in two places before the transaction is committed.

Depending on the degree of resilience and recoverability required, one simply evaluates the alternatives available; and then makes a decision.

Regards,
Paul Received on Sun Mar 09 2003 - 14:06:21 CST