OGG-01028 unexpected LOB record or record fragment
来源:互联网 发布:国家燃烧知乎 编辑:程序博客网 时间:2024/05/01 19:51
今天遇到在初始化goldengate,start replicat reprd, aftercsn xxxxx时出现 OGG-01028错误,错误信息如下
2014-02-14 12:51:49 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, reprd.prm: REPLICAT REPRD started.
2014-02-14 12:51:50 ERROR OGG-01028 Oracle GoldenGate Delivery for Oracle, reprd.prm: unexpected LOB record or record fragment in ./dirdat/t1000151, rba 1
326.
2014-02-14 12:51:50 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, reprd.prm: PROCESS ABENDING.
根据错误信息可知与LOB字段有关,info reprd 查看到seqno, rba 后用./logdump 查看trail 文件内容如下:
Logdump 119 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 2020 (x07e4) IO Time : 2014/02/10 17:35:57.509.800
IOType : 116 (x74) OrigNode : 255 (xff)
TransInd : . (x01) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 6325 AuditPos : 31218704
Continued : Y (x01) RecCount : 105 (x69)
2014/02/10 17:35:57.509.800 LargeObject Len 2020 RBA 1326
Name: RDZW.CON_BZ_ATTACHMENT
After Image: Partition 4 m
0000 0004 0000 070a 0000 0268 000f 432c 0000 07d0 | ...........h..C,....
40a4 30c3 1eb9 3da8 48b6 302b d1ba 0aba 49a6 dc9d | @.0...=.H.0+....I...
cca0 f4e5 4f63 4648 2161 1956 6ddb 3946 34d6 b6d9 | ....OcFH!a.Vm.9F4...
1f52 77f2 c33d 4d67 2af2 552c f43a 3d9c 5af6 af41 | .Rw..=Mg*.U,.:=.Z..A
7c8e 41dc a060 1231 4632 1d54 0623 a2af 159c ea42 | |.A..`.1F2.T.#.....B
2ae4 5594 26e2 a065 4de6 961b 1486 0bb4 a81d 2b30 | *.U.&..eM.........+0
2156 924c fcdf 7496 3d2a a15a f64c e5e5 9a76 6c81 | !V.L..t.=*.Z.L...vl.
Column 4, LOB fragment 616 of 1802
Size 2000 (x07d0)
Offset 1000236 (xf432c)
Logdump 120 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 2020 (x07e4) IO Time : 2014/02/10 17:35:57.509.800
IOType : 116 (x74) OrigNode : 255 (xff)
TransInd : . (x01) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 6325 AuditPos : 31218704
Continued : Y (x01) RecCount : 106 (x6a)
2014/02/10 17:35:57.509.800 LargeObject Len 2020 RBA 3419
Name: RDZW.CON_BZ_ATTACHMENT
After Image: Partition 4 m
0000 0004 0000 070a 0000 0269 000f 4afc 0000 07d0 | ...........i..J.....
000a d71e 6324 2cdb f72e 0334 4a30 4f71 b8f6 af3e | ....c$,....4J0Oq...>
2bd9 ae59 6a69 49c6 54dc ba92 b3b3 9313 97e5 55c0 | +..YjiI.T.........U.
5c95 cfa0 3df1 ef59 535b fce6 6541 2448 d894 35ce | \...=..YS[..eA$H..5.
c273 fe7a f4ae 7f68 e53b 2153 85db b9cc 5d5b 5caf | .s.z...h.;!S....][\.
c858 aac6 0a6c 652e bb4e 4e14 9ed9 3d7e b5ce 5e69 | .X...le..NN...=~..^i
acbf 3001 720e 5783 8c7d 3a8a 9c4d a8d9 5ee7 451b | ..0.r.W..}:..M..^.E.
Column 4, LOB fragment 617 of 1802
Size 2000 (x07d0)
Offset 1002236 (xf4afc)
fragment 617 of 1802显示trail 文件里的record将大的LOB字段分成fragment,如这里一个LOB有在用logdump显示时被分成了1802 fragment,replicat无法在这些fragment中间启动。
解决方法:
选择一个独立的record,在它的rdb启动,如skip 1205,在他之后的rba开始。
- OGG-01028 unexpected LOB record or record fragment
- record- -
- record
- record
- record
- Record
- Record
- record
- record
- Record
- RECORD
- record
- record
- record
- record
- Record
- record
- record
- Java NIO系列
- Div滚动条移动
- 商业智能遇到大数据
- C++的基础知识和易出错误
- 3D 顶点颜色 纹理 材质之间的关系
- OGG-01028 unexpected LOB record or record fragment
- 四舍五入
- IOS 开源库 asyncSocket 的使用心得
- 黑马程序员-----Date和Calendar
- Java synchronized详解
- C/C++ 微软面试题 -链表
- IOS 生成pem证书方法
- 下一代的APACHE HADOOP MAPREDUCE : YARN
- pthread_create如何传递多个参数