Streams advice

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 Received on Thu May 01 2008 - 21:35:00 CDT