GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Replicat issues - Update transformed into Insert is inserting 2 rows, 1 before image and 1 after ima

edited Feb 17, 2018 4:05AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered

Hello

My GoldenGate environment is as follows:

Source:  DB    - 10.2.0.4

               OGG - 11.2.0.1.25

               Extract - Classic

Target: 

               DB    - 12.1.0.2

               OGG - 12.2.0.1.170221

               REPLICAT - Integrated;  Got the same results even after downgrading it to NON-Integrated and with a REPLICAT created as NON-Integrated.

All updates and deletes are converted into inserts by the replicat in the target DB.  Hence, extract has the required parameters to capture the BEFORE IMAGES.

EXTRACT PARAMS :

TRANLOGOPTIONS INCLUDEREGIONID

TRANLOGOPTIONS LOGRETENTION SR

FETCHOPTIONS FETCHPKUPDATECOLS

NOCOMPRESSDELETES FETCHMISSINGCOLUMNS

GETUPDATEBEFORES

REPLICAT PARMAS:DBOPTIONS DEFERREFCONST

DBOPTIONS SETTAG 245867

DBOPTIONS INTEGRATEDPARAMS (COMMIT_SERIALIZATION FULL,
PARALLELISM 1)  -- This was commented out when the replicat was downgraded to NON_INTEGRATED

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center