Book Image

Oracle Goldengate 12c Implementers Guide

Book Image

Oracle Goldengate 12c Implementers Guide

Overview of this book

Table of Contents (21 chapters)
Oracle GoldenGate 12c Implementer's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
GGSCI Commands
GoldenGate Installed Components
Acronyms
Index

Creating the initial configuration


This section describes the concept behind the configuration of GoldenGate and how to set up data replication. For simplicity, the configuration examples are of a basic level and based on one table. They do not necessarily represent a production environment. Chapter 7, Advanced Configuration, provides greater detail.

Tip

You may also wish to refer to the Oracle documentation, Administering Oracle GoldenGate for Windows and UNIX (part number E29388-06), to support your understanding of commands and parameters.

The following steps create a simple GoldenGate unidirectional source to target configuration, where data is replicated from an Oracle Enterprise Manager SYSMAN schema in the PDB1 pluggable database on db12server01 to a TGT schema in the PDB2 pluggable database on db12server02. I have chosen to use the MGMT_AUDIT_LOGS table because it is constantly written to by the user audit process within OEM and provides a good source of data.

Configuring the Manager...