2015-11-09 16:23:54 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, EXTRACT3.prm: EXTRACT EXTRACT3 started.
2015-11-09 16:23:54 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, EXTRACT3.prm: No recovery is required for target file /usr/app/db1/ggs/trails/x1000000, at RBA 0 (file not opened).
2015-11-09 16:23:54 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, EXTRACT3.prm: Output file /usr/app/db1/ggs/trails/x1 is using format RELEASE 11.2.
2015-11-09 16:23:54 ERROR OGG-00717 Oracle GoldenGate Capture for Oracle, EXTRACT3.prm: Found unsupported in-memory undo record in sequence 11566, at RBA 1473040, with SCN 3330.2812655651 (14305053751331) ... Minimum supplemental logging must be enabled to prevent data loss.
2015-11-09 16:23:54 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, EXTRACT3.prm: PROCESS ABENDING.
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)
2015-11-09 16:23:54 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, EXTRACT3.prm: No recovery is required for target file /usr/app/db1/ggs/trails/x1000000, at RBA 0 (file not opened).
2015-11-09 16:23:54 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, EXTRACT3.prm: Output file /usr/app/db1/ggs/trails/x1 is using format RELEASE 11.2.
2015-11-09 16:23:54 ERROR OGG-00717 Oracle GoldenGate Capture for Oracle, EXTRACT3.prm: Found unsupported in-memory undo record in sequence 11566, at RBA 1473040, with SCN 3330.2812655651 (14305053751331) ... Minimum supplemental logging must be enabled to prevent data loss.
2015-11-09 16:23:54 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, EXTRACT3.prm: PROCESS ABENDING.
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)
No comments:
Post a Comment