OGG-00717 : Found unsupported in-memory undo record + Minimum supplemental logging must be enabled to prevent data loss

OGG-00717 : Found unsupported in-memory undo record + Minimum supplemental logging must be enabled to prevent data loss

Possible Cause:
Supplemental logging is not enabled on the database level or the extract is positioned to a point where the supplemental logging has not been enabled i.e an attempt was made to start the extract when the supplemental logging was not enabled on the database.
Solution:
Check if Supplemental logging is enabled
SQL> SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;
SUPPLEME
——–
NO
Enable Supplemental Logging
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
Database altered.
Switch Logfile
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
And attempt to start the extract with begin now option
GGSCI (sev274) 2> alter extract EXTRACT3, begin now
EXTRACT altered.
GGSCI (sev274) 3> start EXTRACT3
Sending START request to MANAGER …
EXTRACT EXTRACT3 starting
GGSCI (sev274) 4> info EXTRACT3
EXTRACT    EXTRACT3  Last Started 2015-11-09 16:29   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:05 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2015-11-09 16:29:20  Seqno 0, RBA 0
                     SCN 0.0 (0)
GGSCI (sev274) 5> !
info EXTRACT3
EXTRACT    EXTRACT3  Last Started 2015-11-09 16:29   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:09 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2015-11-09 16:29:20  Seqno 0, RBA 0
                     SCN 0.0 (0)
GGSCI (sev274) 6> !
info EXTRACT3
EXTRACT    EXTRACT3  Last Started 2015-11-09 16:29   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:03 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2015-11-09 16:55:07  Seqno 11567, RBA 281600
                     SCN 3330.2812657068 (14305053752748)
  • September 11, 2017 | 18 views
  • Comments