Streams advice
Date: Fri, 2 May 2008 12:35:00 +1000
Message-ID: <MPG.228528d242924fb99896b0@news.x-privat.org>
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