Extract abends with "ERROR OGG-01028 partial record at sequence 。。, block 。。block byte 0, rba 。。"

(文档 ID 2159577.1)

 

APPLIES TO:

Oracle GoldenGate - Version 11.2.1.0.32 and later
Information in this document applies to any platform.

SYMPTOMS

Classic Extract abends with following error

eg.,

Oracle GoldenGate Capture for Oracle
Version 12.2.0.1.160223 22933410_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Mar 31 2016 01:07:07

Source Context :
SourceModule : [er.redo.ora.rtc]
SourceID : [/oggcore/OpenSys/src/app/er/redo/oracle/rtc.c]
SourceFunction : [RTC_producer]
SourceLine : [2202]
ThreadBacktrace : [6] elements
: [/u02/ggs_v12.2/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x7fe5bc6073ab]]
: [/u02/ggs_v12.2/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x134) [0x7fe5bc601534]]
: [/u02/ggs_v12.2/libgglog.so(_MSG_ERR_ER_GENERIC_FAILURE(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x30) [0x7fe5bc5e6a02]]
: [/u02/ggs_v12.2/extract(RTC_producer+0x1175) [0x83a255]]
: [/lib64/libpthread.so.0(+0x7851) [0x7fe5b9537851]]
: [/lib64/libc.so.6(clone+0x6d) [0x7fe5b448590d]]

2016-06-16 19:53:26 ERROR OGG-01028 partial record at sequence 188902, block 1667072 block byte 0, rba 853540864.

CHANGES

 Issue affects OGG versions 11.2.1.0.32+ and 12.1.2.1.5+

CAUSE

Bug 20548587 changed the default setting for disable_streamlined_dblogreader from false to true for potential issues with the dblogreader api for rdbms versions prior to 11.2.0.4, but the change seems to apply to all database versions. dblogreader api moves it's read position backwards causing this error

SOLUTION

Restarting the extract may go past the error. If it doesn't as a workaround use the following only if the DB version is Oracle 11.2.0.4 and above

TRANLOGOPTIONS _ENABLESTREAMLINEDDBLOGREADER

Fix is in Bugs 23549184 and 25087704

Note: Extract may abend with errors mentioned in KM note 2246055.1 if both the bug fixes are not applied.