Hi all,
First of all - IANADBA. I'm just a developer / project manager.
Oracle 10.2.0.3 RAC cluster on Intel Linux, ASM on a SAN.
We have a series of instances on our RAC cluster, some of which support
largish 3rd party applications and some "developed in-house" including an
embrionic MIS DW.
Several of these need to exchange data, and currently this is being
achieved using a mix of bulk overnight partial copies and (near real-time,
some delay acceptable) table triggers.
I am keen to investigate the option of shifting to a consolidated approach
using Oracle Change Data Capture (aka Streams).
At some stage in the future we are also unfortunately likely to need to
add a MSSQL database (via Heterogenous Replication?) to this mix.
I've read (and absorbed a fraction of) the Oracle Streams Replication
Administrator's Guide, and think that the configuration option that will
best suit our needs is "Asynchronous AutoLog archive" mode.
Can any Streams-savvy people provide any general advice as to whether I'm
heading down the right or wrong path?
TIA
Geoff M
