Illustration strep039.htm shows an example of a Streams multiple source replication environment. The following sections describe the databases in this environment.
Source/Destination Database
The source/destination database 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
Source/Destination Database
The source/destination database 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.