Oracle GoldenGate Best Practices: Instantiation from an Oracle Source Database (Doc ID 1276058.1)

Last updated on JUNE 27, 2023

Applies to:

Purpose

This document is an introduction to Oracle GoldenGate’s best practices and guidelines for instantiation of a target database from an Oracle Source Database.  This method will allow the customer to start Replicat at a specific point in the trail file created by Extract by using CSN number so the Replicat will not hit any "duplicate" records.  This is a much better initial load methodology than the traditional "handlecollision" solution.

Scope

The document is intended to be a supplement to the existing series of documentation available from Oracle.
The following assumptions have been made during the writing of this document:

• The reader has basic knowledge of Oracle GoldenGate products and concepts.
• Referencing Oracle GoldenGate Version 10 and above.
• Referencing Oracle Version 9.2 and above.
• Referencing OS: All Oracle GoldenGate supported platforms for Oracle.

Details

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