Primary Note - Oracle GoldenGate: Initial Load Techniques and References
(Doc ID 1311707.1)
Last updated on AUGUST 26, 2021
Oracle GoldenGate - Version 9.5_EA to 18.104.22.168.0 [Release 9.5.0 to 12.1] Information in this document applies to any platform.
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.
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.