My Oracle Support Banner

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

Last updated on AUGUST 26, 2021

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.

 

  

 

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Overview
 Terminology
 Prerequisites for Initial Load
 Tools to Perform Initial-Loads
 Loading with a Database Utility
 Instantiation from a Source Oracle Database
 Loading Data from File to Replicat
 Loading Data from Trail to Replicat
 Loading Data from File to Database Utility
 Loading Data with an Oracle GoldenGate Direct Load
 Loading Data with a Direct Bulk Load to SQL*Loader
 Performance during Initial-Loads
 Parallel Processing
 Storage and Network Considerations
 Storage Area Network (SAN) Disk
 Database File System  (DBFS)
 TCP Settings/Network
References

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