RE: Asynchronous change data capture in 10g

  • From: "ramick" <ramick@xxxxxxxxxxx>
  • To: <orclwzrd@xxxxxxxxx>, <gparc@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 4 Apr 2006 13:21:16 -0700

My experience with CDC from 9205 RAC to 10.2.0.1 showed the following bugs:
4645752 [Base 4285404] STREAMS FROM 9IR2 RAC TO 10GR2 PROPAGATOR THROWS
ORA-25292
 Oracle says this is fixed at 9207 with a one-off, but I have not been able
to verify this.

3571054 Streams capture process may dump in RAC
 This is termed as fixed at 9206.

We have not moved off 9205, yet to confirm or deny the fixed statuses of
these.

________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of John D Parker
Sent: Tuesday, April 04, 2006 7:26 AM
To: gparc@xxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Asynchronous change data capture in 10g

I recently asked a similar question and got no response. Evidently we are
the only two. Our experience with a RAC source and single instance target is
not good. Turns out that there is a bug (undocumented negative feature) that
prevents RAC sources from being captured at the target. Oracle is working on
it...

John

gparc@xxxxxxx wrote:

Hi listers,

Platform : Hp-ux 11i / Oracle 10.2.0.2

We are considering using Asynchronous change data capture
to track modifications in our DB.
Does anyone already use it ?

So far, what we can see is :
- it needs Oracle JVM in the DB (although it's based on Streams and
Logminer)
- it doesn't support Lobs columns

Any other pitfalls ?

And don't tell me ACDC is a "Highway to Hell" :-)

Regards

Gilles
--
//www.freelists.org/webpage/oracle-l


________________________________________
New Yahoo! Messenger with Voice. Call regular phones from your PC for low,
low rates.

--
//www.freelists.org/webpage/oracle-l


Other related posts: