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

April 16, 2013 | 1 minute read
Text Size 100%:

Introduction

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

Steven George


Previous Post

Oracle GoldenGate Best Practices: Dual Apply

Steven George | 2 min read

Next Post


Oracle GoldenGate Best Practices: Extracting object ID’s for ALTID Table Mapping

Steven George | 2 min read