Illustration strep052.gif shows the role of the capture database in the Stream replication environment configured by a one of the procedures. This illustration shows the following Oracle databases:
The source database contains the following:
The database objects in the database.
The redo log recording changes to the database objects.
The capture database can be the source database, the destination database, or a third database. The capture database contains the following:
A capture process capturing changes from the redo log of the source database. If the capture database and the source database are the same, then a local capture process captures changes in the redo log at the source database. If the capture database is the destination database or a third database, then the source database redo log is shipped to the capture database, and a downstream capture process captures changes in this redo log.
The capture process converts the changes to logical change records (LCRs) and enqueues the LCRs into a queue.
If the capture database and the destination database are different databases, then a propagation propagates the LCRs to a queue at the destination database. If the capture database and destination database are the same, then the propagation between databases is not needed.
The destination database contains the following:
The queue that contains LCRs that were captured by the capture process.
An apply process that applies the LCRs as changes to the database objects.