My Oracle Support Banner

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

Last updated on FEBRUARY 05, 2020

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 Tableschemaname.tablename currently in R1 to replicat group R2. We are looking for steps doing the same.

Both the Replicats are reading the trails from same Pump

GGSCI> view params pumpname

EXTRACT pumpname
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 schemaname.*;
TABLE schemaname.*;
TABLE schemaname.*;


GGSCI > info all

Program Status Group Lag at Chkpt Time Since Chkpt

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

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.