Goldengate : File to Replicat - Initial Load Techniques (Doc ID 1441172.1)

Last updated on AUGUST 07, 2023

Applies to:

Purpose

GoldenGate Initial Load: Loading Data from File to Replicat.

The document discusses the method of performing an initial-load from File to Replicat, necessary parameters to be configured for the GoldenGate processes, advantages and disadvantages of the method, and an example that illustrates the technique.

This document should be read in conjunction with Document 1311707.1 Primary Note for Oracle GoldenGate: Initial Load Techniques.

Also, refer to the Oracle GoldenGate Windows and UNIX Administrator’s Guide, chapter titled Running an initial data load, for detailed information on all initial load methods.

Scope

The note is intended for new implementations of GoldenGate where the source data needs to be instantiated on the target database in order to replicate the data using GoldenGate.

With initial-loads from File to Replicat, the data is captured directly from the source database tables and is written in canonical format to an Extract file that the Replicat process will use to apply the changes directly to the target database tables.

Note that this method is considerably slower than other Initial Load techniques, given that during the initial-load, no replication occurs until extraction is completed.

An advantage of this method is that Data Transformation can be achieved, either on the source or the target database.

It supports LOBs and encrypted data. Hence, it can be a valid initial loading method when the data contains those.

During the initial load, the change synchronization Extract/Replicat groups perform the extraction and apply of incremental changes that are then reconciled with the results of the load.

Details

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