Home » Server Options » Streams & AQ » Add New Destination (Oracle 10g ,Release 2 ,Windows 2003)
Add New Destination [message #330317] Sun, 29 June 2008 07:10 Go to next message
mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA
Member
I configured streams replication in 3 databases( one source and rest of two destination ).

when I setup streams in 3 databases I used data pump for table and data(Catalog and Transactional).

My source database A. and Destination database are B and C.

Data captured from A and propagate to B and C( for Catalog data),
But For subset(Transactional), data replicate specific database.
And some case Data replicate from B to A and C to A .
Data never replicate B to C or C to B.

Problem 1:

Now I want to add a new database(D) in existing streams environment.

In my source database there are two type data exist(Catalog and Transactional). In my new database(D) I need only catalog data from A.

When streams configuration will complete then Data will propagate from A to D and some case D to A.

How Can I do this?

Problem 2:

In My 3 databases ,I add new database with all data from A.
But Database B and C would not work now.

Report message to a moderator

Re: Add New Destination [message #330720 is a reply to message #330317] Tue, 01 July 2008 00:58 Go to previous message
mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA
Member
Thanks EveryBody

I solved it.
Process:
Capture process rebuild,
Propagation Rebuild,
Set instantiation SCN for tables at the source database,
Set instantiation SCN for tables at the destination database,
and start all process




Thanks

Report message to a moderator

Previous Topic: AQ propagation over internet
Next Topic: Problems on Oracle Streams AQ Examples
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 23:56:17 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.