My Oracle Support Banner

How to set up Streams with minimum down time at the Source Database (Doc ID 1299278.1)

Last updated on FEBRUARY 04, 2022

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.2 [Release 10.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


Goal

The following document provides the steps required to configure a one way streams replication environment with minimum down time at the source database.

Solution

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
Goal
Solution
 Source Database
 1. Prepare the tables for instantiation in the schema to be replicated
 2. Dump a copy of the data data dictionary to the redo stream and record the SCN:
 3. Set up the capture and propagation processes:
 4. Export the schema to be replicated using expdp
 Target Database
 5. Import the schema:
 6. Set up the apply
 7.  Set the instantiation SCN for the schema
 Start Capture Process

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