How To Add an active Database to An Existing Bi-directional Streams Replication Environment (Doc ID 779407.1)

Last updated on MAY 15, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.1.0.6 [Release 9.2 to 11.1]
Information in this document applies to any platform.

Goal

This sample demonstrates adding a site ( a database node) to an existing two-way Streams replication environment while the site is active. A site is an active site if the tables in its schema to be replicated, are being modified by DML (Inserts/Updates/Deletes) . DDL can also be performed on the tables except while the export of the tables is performed for instantiation. Using the procedure detailed below, the existing processes in the streams environment continue to perform their assigned tasks and users continue their activity on the site while the site is added into the replication configuration. This example illustrates two-way capture, propagation and application of the schema DML and DDL change events between three different databases. The sample  adds a third database to an existing bi-directional streams environment.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms