RE: Asynchronous Synchronization of Oracle Databases

We are using Oracle's Asynchronous replication across 21 servers. There are many benefits to replication. We used it on 7.1.6 and have since upgraded to 7.3.3. We use Updatable Snapshots and Master-Master replication for different sets of data.

As far as handling conflicts goes, there are built in capabilities such as Master site priority, latest timestamp, or you can design your own custom conflict solution.

You need Oracle's replication option and it is not a hugh effort to set up. We have been using it in a production environment for almost 2 years now.

If you need more information please send me an e-mail. Enjoy!
chris

> -----Original Message-----
> From: Anke Schirmer [SMTP:ASchirmer_at_stgl.sel.alcatel.de]
> Posted At: Monday, December 01, 1997 10:59 AM
> Posted To: comp.databases.oracle.misc
> Conversation: Asynchronous Synchronization of Oracle Databases
> Subject: Asynchronous Synchronization of Oracle Databases
>
> Hello,
>
> We want to do a synchronisation of a Oracle database into several
> other
> locations. We want to have a asynchronous synchronisation. Therefore
> I
> intended to do this with triggers.
> We have version 7.2 of Oracle installed but we could upgrade to 8.0.3
> if
> necessary. Then we could use updatable snapshots.
> Now my questions:
> -Does anybody has experiences using updatable snapshots or triggers to
> do this synchronisation? What woul be the better solution? Is there
> another solution?
> -What about conflict management during asynchronous synchronisation?
>
>
> I would appreciate an answer
>
> Timo
>
> T.Busch_at_stgl.sel.alcatel.de
>
>
Received on Wed Dec 03 1997 - 00:00:00 CST