sometime you may see your replicat abends with mapping error

message in ggserr.log

UPDATE "OGGTRG"."ZORA" x SET x."NAME" = 'pp',x."HOME" = 'bb',x."AGE" = '33' WHERE x."ID"='1'
Statement length: 92

(S)top display, (K)eep displaying (default):



2020-06-05 07:53:52  WARNING OGG-01431  Aborted grouped transaction on 'OGGTRG.ZORA', Mapping error.

2020-06-05 07:53:52  WARNING OGG-01003  Repositioning to rba 2021 in seqno 15.

2020-06-05 07:53:52  WARNING OGG-01151  Error mapping from OGGSRC.ZORA to OGGTRG.ZORA.

2020-06-05 07:53:52  WARNING OGG-01003  Repositioning to rba 2021 in seqno 15.

if you check discard file it says missing key column

[oracle@oel6-node04 dirrpt]$ cat rpdw.dsc
Oracle GoldenGate Delivery for Oracle process started, group REP_12 discard file opened: 2020-06-05 07:48:54.442915
Key column ID (0) is missing from update on table OGGTRG.ZORA
Missing 1 key columns in update for table OGGTRG.ZORA.
Current time: 2020-06-05 07:53:52
Discarded record from action ABEND on error 0


Aborting transaction on ./dirdat/pw beginning at seqno 15 rba 2021
                         error at seqno 15 rba 2021
Problem replicating OGGSRC.ZORA to OGGTRG.ZORA
Mapping problem with compressed update record (target format)...

on source check if supplemental loggin enabled for table at table or schema level

in our case both disabled

GGSCI (oel6-node03.localdomain) 8> info trandata oggsrc.zora

Logging of supplemental redo log data is disabled for table OGGSRC.ZORA.

GGSCI (oel6-node03.localdomain) 9>  info schematrandata oggsrc

2020-06-05 08:00:49  INFO    OGG-01786  Schema level supplemental logging is disabled on schema OGGSRC.

so i enabled supplemental logging at schemalevel so that in future all new tables have it enabled automatically and you don’t get this error. you can enable at table level also but then you need to do it everytime a new table is created

GGSCI (oel6-node03.localdomain) 10> add schematrandata oggsrc

2020-06-05 08:02:13  INFO    OGG-01788  SCHEMATRANDATA has been added on schema oggsrc.

2020-06-05 08:02:13  INFO    OGG-01976  SCHEMATRANDATA for scheduling columns has been added on schema oggsrc.

start replicat aftercsn.

in my case there were no other transcations happening on any other table so i did below otherwise you need to check your case and take appropriate action

on source check current scn

SQL> select current_scn from v$database;

CURRENT_SCN
-----------
    1510813
GGSCI (oel6-node04.localdomain) 13> start replicat REP_12, aftercsn 1510813

Sending START request to MANAGER ...
REPLICAT REP_12 starting


GGSCI (oel6-node04.localdomain) 14>  info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
REPLICAT    RUNNING     REP_12      00:00:00      00:00:05