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.