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

Last updated on AUGUST 31, 2023

Applies to:

Goal

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.

Solution

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