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

dquinn_at_uk.oracle.com (Dave Quinn) wrote:

I really don't think log shipping or TPC is the answer either....

>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
>

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Gordon E. Hooker MACS PCP
25 Clarke Street Ripley Queensland Australia Phone 61-7-32940555
Email gordonh_at_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. Received on Tue Feb 06 1996 - 00:00:00 CET