Illustration strms047.gif shows an example real-time downstream capture configuration that involves the following steps:

  1. Users make changes to database objects at a source database.

  2. The log writer process (LGWR) at the source database sends redo data to the downstream database while, at the same time, LGWR logs these changes in the online redo log at the source database.

  3. Remote file server (RFS) at the downstream database receives the redo data over the network from the LGWR at the source database.

  4. RFS logs the redo data in the standby redo log at the downstream database.

  5. The archiver writes the redo data in the standby redo log to archived redo log files at the downstream database.

  6. At the downstream database, a capture process captures changes standby redo log whenever possible and in the archived redo log files whenever necessary and enqueues these changes as LCRs into a queue at the downstream database.