Replication should source from source server SRC and replicate in both STG1 and STG2 staging servers.
Configure CDC for STG1 with the following configuration: SRC_OGG_OBJECT_GROUP = SRC SRC_SETUP_OGG_PROCESSES = YES STG_OGG_OBJECT_GROUP = STG1 STG_SETUP_OGG_PROCESSES = YES ENABLE_ODI_CDC= YES
Start the journal and follow the instructions in the readme to set up the Oracle GoldenGate processes in SRC and STG1.
Configure CDC for STG2 with the following configuration:
SRC_OGG_OBJECT_GROUP = SRC (Use the same name as for STG1)
SRC_SETUP_OGG_PROCESSES = NO (The processes have been set up with STG1)
STG_OGG_OBJECT_GROUP = STG2
STG_SETUP_OGG_PROCESSES = YES
Start the journal and follow the instructions in the readme to set up the Oracle GoldenGate processes in SRC and STG2. Note that playing the configuration on SRC again will not recreate a capture process, trail files, or definition files. It will simply create a new Oracle GoldenGate Datapump process to push data to STG2.
Knowledge Module Options Reference JKM Oracle to Oracle Consistent (OGG)
LOCAL TEMP DIR
N B _ A P P L Y _ P R O C E S S
TRAIL FILE SIZE
SRC OGG OBJECT GROUP
SRC DB USER
SRC DB PASSWORD
Default temp directory.
Knowledge Modules Reference Guide
DB password of the source schema
DB user of the source schema
Logical schema of the source model.
Name of the source Oracle GoldenGate group
Trail file size in mega bytes.
Number of Replicat processes.
Full path to a temporary folder into which the Oracle GoldenGate configuration files will be generated.
RDBMS version compatibility
Default Value No
Validates KM options and RDBMS version.