My Oracle Support Banner

How To Setup One-Way SCHEMA Level Streams Replication (Doc ID 301431.1)

Last updated on AUGUST 31, 2023

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: to 11.2.x


Starting from release 9.2, Oraclehas introduced a more flexible and efficient way of implementing replication using Streams. OracleStreams enables the sharing of data and events in a data stream, either within a database or from one database to another.

In a nutshell, replication using Oracle Streams is implemented in the following way:
1.-A background capture process is configured to capture changes made to tables,schemas, or the entire database. The capture process captures changes from the redo log and formats each captured change into a logical change record (LCR). The capture process uses logminer to mine the redo/archive logs to format LCRs.
2.-The capture process enqueues LCR events into a queue that is specified.
3.-This queue is scheduled to Propagate events from one queue to another in a different database.
4.-A background apply process dequeues the events and applies them at the destination database.

The steps below are intended to assist Replication DBAs in setting up and configuring Streams Replication. The sample code outlines the steps to set up one-way streams replication at Schema level.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Sample Code 
 Sample Output

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.