Re: Streams advice

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 21 Aug 2007 18:28:12 -0700
Message-ID: <1187746090.48628@bubbleator.drizzle.com>

sybrandb_at_hccnet.nl wrote:

> On Tue, 21 Aug 2007 14:03:45 -0700, DA Morgan <damorgan_at_psoug.org>
> wrote:
> 

>> And here comes the fun.
>>
>> You are going from a RAC cluster which means each and every node has its
>> own redo log thread which means you need to have streams running on each
>> node.

>
> Not according to Metalink

Please send me the link.

Mining log files in Data Guard is exactly the same as mining log files in Streams ... written by the same team of developers so it should be. With Data Guard you must have install on every node.

>> Unless you have some need for the complexity of
>> publish-transform-subscribe I'd take a serious look at using Change
>> Data Capture. It is far easier to implement. Also make sure that you
>> do the following:
>>
>> alter database force logging;
>> alter database add supplemental log data;
>> --

> Is Change Data Capture available in 9i? Don't think so.

You are correct. Did I miss the version number in the OP's post?

> Yes, I am facing to 'synchronize' two 9i databases, where half of the > tables have no PK...

Yes I did. Sorry.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Aug 21 2007 - 20:28:12 CDT