Re: Symmetric replication

Hi Sara

       If business permits, may be you should opt for a asynchronous mode of propagation, this way in case of failure of replicated site, the deferred queue could be pushed later on after the resumption of replication.

Otherwise, if you want to continue for synchronous mode of propagation, you could write triggers or procedures which would store data while one of the sites is down and when the replicated site is up you could push this accumulated data to replicated site before bringing up synchronous replication again.

Volume of rows and speed of your network should be a major concern, at times, pushing the rows is quite time consuming and despite best of your efforts, the replicated site would still be not in sync with your source database.

Have ample space ready before hand in the DEFAULT TABLESPACE of replication administrator OR whichever Oracle id is accumulating the rows, since during times of failure of replicated site, the deferred queue will fill up very quickly.

If your system and network speed is impressive, perhaps, you could go for an immediate halt of synchronous replication and switch to async replication, accumulate data and then when replicated site is back to business, you could push rows and switch back to sync replication.

Rajeev
cliff92_at_hotmail.com

In article <79rr0u$vi4$1_at_minix.vbo.dec.com>,   "Sara Filipponi" <Sara.Filipponi_at_Digital.com> wrote:
> Hi. I must use advanced replication to develope a critical application, in
> particular synchronous data propagation between two master sites.
> When one of the two site fails, I could stop the replication activity but
> when the site arises and is ready, how I can restore the database to be
> align with the one on the first site? 'Cause I think it is not sufficient to
> resume the replication activity, and I would not to apply an import/export
> if the site is down for few minutes..
> Perhaps, do I have to switch to deferred propagating mode before stopping
> replication activiy and then, when the site arises, push the deferred queue
> and switch from asynchronous to synchronous propagation? I don't know if it
> could work.
> Every idea is appreciated, thanks a lot to everyone who has spent some time
> to read this post.
>
> Sara
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Feb 15 1999 - 00:00:00 CET