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.