I am using Oracle GoldenGate 19.1.0.0.4 to do replication between 19c and 11.2.0.4 database. Replication is happening fine between two databases but when I use GetBeforeCols extract parameter to capture before image of couple of columns of a certain table then replicate process abends on target system with below error.
OGG-01920 Oracle GoldenGate Delivery for Oracle, reprac.prm: Missing COMPARECOLS column "SAL" in before image, while mapping to target table "SCOTT.EMP". Add the column to GETBEFORECOLS.
where as on target replicat file column is present in ComapreCols
I am also share my source extract and traget replicat parameter files below.
=============
SOURCE
============
EXTRACT exrac
USERID c##ggs_owner@rac, password ggs_owner
EXTTRAIL /u04/app/oracle/ogg/dirdat/rac/ex
TRANLOGOPTIONS EXCLUDEUSER rac_pdb1.c##ggs_owner
TRANLOGOPTIONS INTEGRATEDPARAMS (_LOGMINER_READ_BUFFERS 256, PARALLELISM 2)
LOGALLSUPCOLS
UPDATERECORDFORMAT FULL
SOURCECATALOG rac_pdb1
DDL INCLUDE ALL, EXCLUDE OBJTYPE 'SNAPSHOT', EXCLUDE OBJTYPE 'SNAPSHOT LOG'
SEQUENCE SCOTT.STUDENTS_ROLLNO_SEQ;
SEQUENCE SCOTT.SRNO_SEQ;
TABLE SCOTT.emp, GETBEFORECOLS(ON UPDATE KEYINCLUDING (SAL,COMM));
TABLE SCOTT.dept;
TABLE SCOTT.promotion;
==============
TARGET
==============
REPLICAT reprac
USERID ggs_owner@orcl, password ggs_owner
DBOPTIONS INTEGRATEDPARAMS(COMMIT_SERIALIZATION FULL, _ARRAY_OPERATION N, PARALLELISM 2, MAX_PARALLELISM 2)
DBOPTIONS SUPPRESSTRIGGERS
--BATCHSQL
ASSUMETARGETDEFS
DISCARDFILE /u02/oracle/ogg/discards_reprac.dsc, PURGE
DBOPTIONS SETTAG 0123
MAP rac_pdb1.scott.emp, TARGET scott.emp, COMPARECOLS (ON UPDATE KEYINCLUDING (SAL,COMM));
MAP rac_pdb1.scott.dept, TARGET scott.dept;
MAP rac_pdb1.scott.promotion, TARGET scott.promotion;