OGG-01028 partial record at sequence extract abended DBACLASS
OGG-01028 partial record at sequence extract abended, use any of the below two solution.
oracle replicationintermediate
by OracleDba
13 views
📋Steps in this guide1/2
1
Overview
If extract process in goldengate abend with OGG-01028 partial record at sequence error, then you below solution.
PROBLEM:( snippet from the extract log)
SOLUTION:
Code/Command (click line numbers to comment):
123456789
2016-12-25 14:05:41 INFO OGG-01738 BOUNDED RECOVERY: CHECKPOINT: for object pool 2: p57354_Redo_Thread_2: start=SeqNo: 8786, RBA: 3756633616, SCN: 2718.265350089 (11673986460617), Timestamp: 2
016-12-25 14:05:40.000000, Thread: 2, end=SeqNo: 8786, RBA: 3756633616, SCN: 2718.265350089 (11673986460617), Timestamp: 2016-12-25 14:05:40.000000, Thread: 2.
Source Context :
SourceModule : [er.redo.ora.rtc]
SourceID : [/scratch/debassah/view_storage/debassah_sparcfbo/oggcore/OpenSys/src/app/er/redo/oracle/rtc.c]
SourceFunction : [RTC_producer]
SourceLine : [2202]
2016-12-25 17:17:43 ERROR OGG-01028 partial record at sequence 5439, block 7996672 block byte 0, rba 4094296064.2
Section 2
There are two methods to fix it.
1. Restart the extract ( most of the time restart fix the issue) 2. If restart is not helping , then add the below parameter in extract and restart.
TRANLOGOPTIONS _ENABLESTREAMLINEDDBLOGREADER
Comments (0)
Please to add comments
No comments yet. Be the first to comment!