Best Practices from Oracle Development's A‑Team

Oracle GoldenGate Best Practices: Oracle Streams to Oracle GoldenGate Conversion for Reporting Databases


Oracle GoldenGate is the strategic replication solution for Oracle Database and for heterogeneous databases. Given the strategic nature of Oracle GoldenGate, Oracle Streams will continue to be supported, but will not be enhanced. For this reason, some Oracle Streams customers may prefer to migrate their replication environments to Oracle GoldenGate.

Main Article

The goal of this document is to provide a step-by-step explanation of the migration process for a simple, unidirectional replication environment. It describes how to stop Oracle Streams, find the SCN (System Change Number) at which Streams was stopped, and finally, how to use this timing information as a starting point for Oracle GoldenGate replication. Because the replication environments are globally consistent at any time, there is no need to move/migrate or re-instantiate the data in any way. The entire migration process simply deals with the reconfiguration of the replication environment.

This document describes how to migrate an Oracle Streams environment that meets the following guidelines:

  • Single source with a single, read-only target, such as a reporting database—no conflict detection or resolution required.
  • Simple table-, schema-, or database-wise, one-to-one replication—no transformations or filtering required.

Although both Oracle Streams and Oracle GoldenGate support more complex replication environments, the complexities of these advanced features require a more customized approach, and are outside the scope of this document.

This document was authored by Volker Kuhr and Steven George

The complete document can be found on the Oracle Support site as Document ID:1383303.1

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha