supplemental log group

Posted by Roshan on Mar 08, 2022; 9:36am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/supplemental-log-group-tp10724.html

Oracle DB 12.1.0.2
OGG 18.1.0

Dear Erman,

kindly advise whether the ALWAYS supplemental log groups can be dropped. My aim is to allow PK UPDATE -> DELETE AND INSERT on Striim. I often get error:
Unexpected Exception. Message: Please provide the full image for insertion as PKUpdateHandlingMode is set as DELETE and Insert

I suppose because of the ALWAYS condition I am getting error.

Table DDL entry:
         SUPPLEMENTAL LOG GROUP "GGS_130565" ("ARTICLE_CODE_V") ALWAYS,
         SUPPLEMENTAL LOG GROUP "GGS_144462" ("ARTICLE_CODE_V") ALWAYS,
         SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS,
         SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS,
         SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS,
         SUPPLEMENTAL LOG DATA (ALL) COLUMNS

Regards,

Roshan