Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Replication

Re: Replication

From: David <darussell_at_email.msn.com>
Date: 1998/02/08
Message-ID: <e3rTTFON9GA.209@upnetnews03>#1/1

It you have made a design decision to allow the data to be re-entered at another master site, then the easiest way to deal with the duplicate data arriving is to use the Latest Timestamp conflict resolution routines. To avoid conflicts caused by duplicate timestamps (> 2 master sites) use a second conflict handler e.g. site priority. Oracle7 suffers a number of performace problems when pushing the deferred queue if a row has a conflict, especially if you have transactions with large nunbers of rows. I would recommend benchmarking these cases. Oracle8 still has some of these problems but they can be resolved by using the parallel propagation mechanism.

One of the most important factors to consider with replication systems is that you understand your backup / recovery strategy. What ever strategy you choose it must be co-ordinated, options are :

Regards
David Russell Received on Sun Feb 08 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US