Illustration strep043.htm shows an example adding a source/destination database to a Streams multiple source replication environment. The following sections describe the databases in this environment.

Existing Source/Destination Database

Additional configuration includes:

• A SYS.AnyData queue to stage changes from the new source database (optional)
• Each shared object prepared for instantiation
• A propagation for the added database
• Instantiation SCN set for each shared object for the added source database
• An apply process for the added source database
• Rule sets for the added propagation and apply process
• A database link for the added propagation

Added Source/Destination Database

Additional configuration includes:

• One or more SYS.AnyData queues
• Supplemental logging specifications
• Each shared object prepared for instantiation
• One or more capture processes
• One propagation for each of the other destination databases
• Instantiation SCN set for each shared object for each of the other source databases
• One apply process for each of the other source databases
• Rule sets for the capture process(es), propagation(s), and apply process(es)
• Conflict resolution if necessary
• A database link for each propagation

Additional Source/Destination Databases

The environment may include additional source/destination databases.