Re: Oracle replication wasRe: Sybase 11 TPCC on DEC (your comments please)
Date: 1996/01/27
Message-ID: <4edu8k$h31_at_news-e1a.megaweb.com>#1/1
heabrujac_at_aol.com (Heabrujac) wrote:
>I have worked with both Sybase's and Oracle's replication methods. And
>replicate data can become inconsistent with both systems. Oracle uses a
>set of deferred transaction tables and job queues. The two phase commit
>ensures delivery of a deferred transaction to a replicate site. It does
>not guarantee that the deferred transaction will be applied correctly at
>the replicate site. Sybase can also guarentee delivery of a transaction
>to a replicate site, but the transaction may or may not be successfully
>applied at the replicate site.
I'm not sure how Symmetric Replication handles transactions which were not successfully applied. However, in the case of Sybase Replication Server, unsuccessfull transactions are (configurably) kept and the replicate database connection is suspended until someone resolves the problem - which may require either re-trying the transaction or dropping it.
Greg Carter Received on Sat Jan 27 1996 - 00:00:00 CET