This illustration shows the details of the primary database ps1.example.com
Oracle Streams configuration, including the following mechanisms:
One queue that is used by the capture process, propagations, and apply processes.
A capture process that captures changes in the redo log and converts relevant changes into LCRs, which it enqueues. The capture process captures a change regardless of whether its tag is NULL
.
One propagation that propagates captured changes to ps2.example.com
. The propagation propagates all changes except changes with a tag of '2'
.
One propagation that propagates captured changes to ps3.example.com
. The propagation propagates all changes except changes with a tag of '3'
.
One propagation that propagates captured changes to ps4.example.com
. The propagation propagates all changes except changes with a tag of '4'
.
One apply process that applies changes from ps2.example.com
. These changes have a tag of '2'
in the redo log.
One apply process that applies changes from ps3.example.com
. These changes have a tag of '3'
in the redo log.
One apply process that applies changes from ps4.example.com
. These changes have a tag of '4'
in the redo log.
One propagation to propagate locally captured LCRs to mult2.example.com
and another propagation to propagate locally captured LCRs to mult3.example.com
.