Book Image

Oracle Goldengate 12c Implementers Guide

By : John P Jeffries
Book Image

Oracle Goldengate 12c Implementers Guide

By: John P Jeffries

Overview of this book

The book is aimed at Oracle database administrators, project managers, and solution architects who wish to extend their knowledge of GoldenGate. The reader is assumed to be familiar with Oracle databases. No knowledge of GoldenGate is required.
Table of Contents (16 chapters)
12
A. GGSCI Commands
13
B. GoldenGate Installed Components
14
C. Acronyms
15
Index

Performing the initial load

Let's now step through the necessary tasks required to perform the initial load using the File to Replicat instantiation method. For small and simple data synchronization with no transformations, this is the preferred solution.

The example architecture

This example assumes that the target tables are truncated and are identical in structure to the source tables. The configuration includes the following tasks:

  • The Initial load: This specifies the Direct Load data synchronization
  • The one-way replication: Change data capture and delivery

The following system schematic diagram illustrates the architecture and naming convention used in this chapter's examples:

The example architecture

Direct Load instantiation

We will use the Direct Load instantiation method to perform our initial load from the Oracle 12c multitenant container database, starting with the initial data capture configuration.

Configuring initial data capture

The first step is to create the initial capture Extract parameter file...