IgnoreDelete and IgnoreUpdate parameters in Oracle GoldenGate

 IgnoreDelete and IgnoreUpdate parameters in Oracle GoldenGate

This article  covers Oracle GoldenGate IgnoreDelete and IgnoreUpdate parameters for Oracle GoldenGate

  • IGNOREUPDATES Parameter
  • IGNOREDELETES Parameter

 

NOTE : The parameters used in this article could be used either in Extract,Data pump or Replicat parameter file.

As a task you should try to use these parameters in Extract and Pump file as well and then check stats.

Prerequisites

This Parameters we can use after configure GG setup  & DML replication between two oracle databases.

Check below article for  Oracle to Oracle GoldenGate Unidirectional Replication 

GoldenGate: Oracle to Oracle GoldenGate Unidirectional Replication

Update replicat process by adding ignoreupdates & ignoredeletes Parameters

GG2:

On target side connect to GGSCI

Check replicat process status 

Now make connection to database

Update the parameter file for the Replicat group ‘repint’ and add these two parameters :

IGNOREUPDATES

IGNOREDELETES

Restart replicat process as

Check repint process info 

To check information related to any parameter in GOLDENGATE use below command:

info param <paramanme>

On SOURCE  GG1 :

Insert records on DEPT table

On Target GG2 :

On Source GG1 :

Update a row into DEPT table

Check stats of EXTINT  process 

Check stats of DPINT process 

On Target GG1 :

Check stats of REPINT process(REPLICAT)

Replicat process ignored a update  transaction. Now we will try with DELETE option

On SOURCE GG1 :

DELETE  a record from DEPT table

Check stats of EXTINT  process 

Check stats of DPINT process 

On TARGET GG2:

Check stats of REPLICAT  process 

Replicat process ignored a update & DELETE   transactions.

NOTE : The parameters used in this guide could be used either in Extract,Data pump or replicat parameter file. As a task you should try to use these parameters in Extract and Pump file as well and then check stats.

 

Thanks for browsing ktexperts.com

 

 

Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

Add Comment