How to add new table to existing GoldenGate Replication(Oracle to Oracle)

How to add new table to existing GoldenGate Replication(Oracle to Oracle)

In this article we will see how to add new table to existing GoldenGate Oracle to Oracle replication.

Please check below link for GG installation for Oracle to Oracle

GoldenGate: Oracle to Oracle GoldenGate Unidirectional Replication

Now we will add new table to existing setup
On Source database :

Create table on Scott

On Target database :

Create table target where you want to replicate

Note : Incase DDL replication already enabled no need to create table

On Source GGSCI :

Check process running on GGSCI

Stop the Extract process(EXTINT)

Stop datapump extract process(DPINT)

Now edit the extint process

Add TABLE SCOTT.TEST1  line (if you want replicate entire schema the keep TABLE SCOTT.*)

Now edit dpint process

Add TABLE SCOTT.TEST1  line (if you want replicate entire schema the keep TABLE SCOTT.*)

On Target GGSCI:

Stop the replicate process(REPINT)

Now edit the replicat process(REPINT)

Add the param MAP scott.test1,target  scott.test1

On Source GGSCI :
Login with ggamdin credentials

Add Trandata on scott.test1

Start extract process(EXTINT)

Start datapump process(DPINT)

Check process running or not 

On Target GGSCI
Check processes

Start replicate process(REPINT)

Check processes

On Source SCOTT user
Perform the transactions on test1 table

On Source GGSCI

Check stats of EXTINT and DPINT

On Target scott user:

Check the records are replicated or not

Please follow the above steps to replicate new table to existing GG Setup

Perform all DML tx’s and check on Target side

 

Thanks for browsing ktexperts……

 

Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

One thought on “How to add new table to existing GoldenGate Replication(Oracle to Oracle)

Add Comment