Re: Question on replication

Thanks for your help first!

I know I can get all the transactions immediately if the propagation mode is 'Async'. But our requirement is to use the 'Sync' mode. Therefore, the concept of scheduled links will not be applied in this case since there will be no deferred transaction. All transactions will either be commited or rollback at all sites within the same transaction in my case.

As a result, if the master definition site failed, we will choose another master site to serve as the primary site. But what if the original master definition is up and recovered, we need to syncronize the data in this site. Since the propagation mode is syncronous, there will be no defered transactions buffered at the backup site and will not push all the changes during the downtime to the primary definition site. So one of the alternative is to re-create the master definition site by export/import but this is not possible for us to shutdown the machines for such a long time.

That's the scenario. Do you have any suggestion?

Thanks!

Cyrus

nasof_at_hotmail.com wrote:

> Have you not tested this?
>
> You should get the transactions immediatly applied during the
> time you set for the "schedule Link".
>
> Let me know what issues you are facing, Im sure I can give some
> help.
>
> -Frank
>
> In article <365ECF0E.BCB132B3_at_net.polyu.edu.hk>,
> cyrus_at_net.polyu.edu.hk wrote:
> > Hi all experts,
> >
> > I have setup two master sites by using the replication option
> > provided by Oracle 8.0.5 Enterprise on NT. Can anyone tell me or give me
> > some ideas on how to recover a failed master definition sites from
> > another master sites when the original master definition site is up
> > again? Does Oracle provide some tools that can push/copy all the
> > transactions which have applied on the fail-over sites but not on the
> > master definition site during its down time.The requirement is similar
> > to that of archive log mode but it is used in a multimaster database
> > environment.
> >
> > Many thanks in advance!
> >
> > Regards,
> > Cyrus
> >
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Nov 30 1998 - 08:59:51 CST