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

dquinn@uk.oracle.com (Dave Quinn) wrote: I really don't think log shipping or TPC is the answer either.... >heabrujac@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 > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Gordon E. Hooker MACS PCP 25 Clarke Street Ripley Queensland Australia Phone 61-7-32940555 Email gordonh@acslink.net.au _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ It is far far better to remain silent and appear a fool then to open ones mouth and remove all doubt. Anon.