This illustration shows the role of the capture database in the Stream replication environment. 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.
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.