Re: Oracle replication wasRe: Sybase 11 TPCC on DEC (your comments please)

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.

That is true - in the case where a transaction cannot be applied successfully, but was transferred correctly to the remote site, then the transaction is logged into an error table. When the dba fixes whatever caused the problem (lack of space etc) then the transaction can be re-executed.

This seems like the most logical way of dealing with the problem (to me anyway).

Not sure what Sybase does.

Dave Received on Mon Feb 05 1996 - 00:00:00 CET