OGG-00717-Found unsupported in-memory undo record in sequence ... Minimum supplemental log

Problem:

ERROR   OGG-00717  Found unsupported in-memory undo record in sequence 3, at RBA 1089040, with SCN 0.1030748 (1030748) ... Minimum supplemental log
ging must be enabled to prevent data loss.

I got an error while starting extract ext1;it abended.Viewed report then I saw;


Solution:

1. Make sure supplemental logging is enabled properly


SQL>SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;
---------
YES

If it is not enabled, use the following commands to enable it.


SQL>ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
SQL>ALTER SYSTEM SWITCH LOGFILE;

2. Alter the extract to a position when the supplemental logging has been enabled.


GGSCI>alter extract, ext1 begin now


3)Then start extract ext1.

Reference:OGG Error "OGG-00717: Found Unsupported In-Memory Undo Record in ..." When Starting, Extract Abends [ID 1362136.1]