Moving One Table From An Existing Running Integrated Replicat Group To Another Classic Replicat (Doc ID 2262603.1)

Last updated on JUNE 13, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Goal

We want move One Table "TRANSACTION_DB"."RDS_TXN_DTLS" currently in RTRDB03 to replicat group RTRDB01. We are looking for steps doing the same.

Both the Replicats are reading the trails from same Pump

GGSCI> view params PCTC01

EXTRACT PCTC01
SETENV (ORACLE_HOME="<path>")
SETENV (ORACLE_SID="<DB SID>")
userid *****@******, PASSWORD ***********  BLOWFISH ENCRYPTKEY DEFAULT


RMTHOST xx.xx.xx.xx , mgrport 7809
rmttrail ./dirdat/CDC/TD
passthru
TABLE STATICTRAINDB.*;
TABLE UDMDB.*;
TABLE TRANSACTION_DB.*;


GGSCI > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
JAGENT RUNNING
REPLICAT RUNNING RTRDB01 00:00:05 00:00:11---Is in Integrated Mode
REPLICAT RUNNING RTRDB03 00:00:09 00:00:46----Is in Classic Mode
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms