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.
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
Previous Topic: AQ propagation over internet
Next Topic: Problems on Oracle Streams AQ Examples
Goto Forum:
  


Current Time: Thu Mar 28 23:37:44 CDT 2024