This illustration shows an example adding a source/destination database to an Oracle Streams multiple-source replication environment.

Additional configuration for existing source/destination databases includes:

• An 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

Additional configuration for the added source/destination database includes:

• One or more ANYDATA queues

• Supplemental logging specifications

• Each shared object prepared for instantiation

• One or more capture process(es) and/or synchronous capture(s)

• 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), synchronous capture(s), propagation(s), and apply process(es)

• Conflict resolution if necessary

• A database link for each propagation

The environment can include additional source/destination databases.