Primary Note - Oracle GoldenGate: Initial Load Techniques and References (Doc ID 1311707.1)

Last updated on SEPTEMBER 18, 2023

Applies to:

Oracle GoldenGate - Version 9.5_EA to 12.1.2.0.0 [Release 9.5.0 to 12.1]
Information in this document applies to any platform.

Purpose

Oracle GoldenGate (OGG) replicates transactional data from one database to another database (optionally the same as the source database). The purpose for the replication may vary by installation but the mechanism creates an implicit requirement that, in all but a few cases, the source and target database tables must be in sync prior to beginning replication.

GoldenGate refers to the process of syncing the databases as Initial Load. An initial load takes a copy (or specified segment) of entire source tables, transforms the data if necessary, and applies it to the target tables so that the movement of transaction data begins from a synchronized state.

This paper documents the varieties and uses of the many types of initial load available and provides reference to other Notes for further information and related documentation.

Scope

This document is valid for all supported releases of Oracle GoldenGate. When a feature is only available for certain releases/databases, this is mentioned within the corresponding section.

The note covers the major methods of doing an Initial Load and and refers briefly to the means for determining the appropriate method for use in a given situation.

The document is to be read in conjunction with the supplied Oracle GoldenGate documentation applicable to your release.

References:

Oracle GoldenGate Documentation

Initial Load is discussed in the Oracle® GoldenGate Windows and UNIX Administrator’s Guide, for GoldenGate release 11g Release 2, refer to Chapter: Running an Initial data Load

For details of GoldenGate Support Lifetime Policy, refer to Lifetime Support Policy: Coverage for Fusion Middleware Products

Ask Questions, Get Help, And Share Your Experiences With This Article

Would you like to explore this topic further with other Oracle Customers, Oracle Employees, and Industry Experts?

Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article.
Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for GoldenGate, Streams and Distributed Database.