Home » Server Options » Replication » OGG-01921 Oracle GoldenGate Delivery for Oracle, rep1.prm: Missing GETBEFORECOLS with conflict det (Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO)
OGG-01921 Oracle GoldenGate Delivery for Oracle, rep1.prm: Missing GETBEFORECOLS with conflict det [message #641007] Sat, 08 August 2015 21:42
Dharmat@gmail.com
Messages: 1
Registered: August 2015
Junior Member
Hi All,
I am trying CDR(conflict data resolution) but I am getting the following error
2015-08-08 18:09:44 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, rep1.prm: REPLICAT REP1 started.
2015-08-08 18:09:44 ERROR OGG-01921 Oracle GoldenGate Delivery for Oracle, rep1.prm: Missing GETBEFORECOLS with conflict detection enabled in target table SCOTT.INVENTORY.
2015-08-08 18:09:44 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep1.prm: PROCESS ABENDI
These are my params
extract ext1
userid ggs_owner, password ggs_owner
rmthost 192.168.56.102, mgrport 7810
rmttrail /oradata/gg/dirdat/lt
DDL INCLUDE ALL
TABLE scott.inventory &
GETBEFORECOLS (ON UPDATE KEYANDMOD, ON DELETE ALL);

replicat REP1
userid ggs_owner, password ggs_owner
assumetargetdefs
DDL INCLUDE ALL
DDLERROR DEFAULT IGNORE RETRYOP
REPERROR (-1, IGNORE)
REPERROR (1403, DISCARD)
DISCARDFILE /oradata/gg/discard.txt, append,
MAP scott.inventory, TARGET scott.inventory,
COMPARECOLS (ON UPDATE ALL, ON DELETE ALL),
RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMIN (last_dml))),
RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, OVERWRITE)),
RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD));
~
PLease let me know how to reslove the issue
Thanks in advance
Previous Topic: Replication from one database to other database
Next Topic: adding checkpoint table
Goto Forum:
  


Current Time: Mon Nov 20 07:48:32 CST 2017

Total time taken to generate the page: 0.01718 seconds