我的操作如下：停掉源端抽取行程，洗掉附加日志，添加附加日志，啟動抽取行程
然后目標端的復制行程就報錯如下：
Aborting transaction on /oradata/goldengate/dirdat/cg beginning at seqno 8754 rba 4016844
error at seqno 8754 rba 4016844
Problem replicating GS_YW.DJ_ZRRDA to GS_CXTJ.DJ_ZRRDA
Mapping problem with compressed update record (target format)...
*
SJTB_SJ = 2018-11-28 11:54:13.92918
*
Process Abending : 2018-11-28 11:54:13
Oracle GoldenGate Delivery for Oracle process started, group RGS_CX1 discard file opened: 2018-11-28 11:54:50
Key column DJXH (0) is missing from update on table GS_CXTJ.DJ_ZRRDA
Missing 1 key columns in update for table GS_CXTJ.DJ_ZRRDA.
Current time: 2018-11-28 11:54:51
Discarded record from action ABEND on error 0
使用logdmp工具，查看這條rba記錄，發現缺失欄位，如下：
Logdump 158 >pos 4016844
Reading forward from RBA 4016844
Logdump 159 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: B (x42)
RecLength : 0 (x0000) IO Time : 2018/11/28 11:01:05.015.218
IOType : 15 (x0f) OrigNode : 255 (xff)
TransInd : . (x00) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 41516 AuditPos : 182935744
Continued : N (x00) RecCount : 1 (x01)
2018/11/28 11:01:05.015.218 FieldComp Len 0 RBA 4016844
Name: GS_YW.DJ_ZRRDA
Before Image: Partition 4 G b
Bad compressed block, found length of 24 (x0018), RBA 4016844
GGS tokens:
5200 0014 4141 4177 6a48 4141 4b41 4144 5033 4d41 | R...AAAwjHAAKAADP3MA
414c 0001 4c00 000e 3136 3232 3332 3135 3730 3034 | AL..L...162232157004
3136 3600 000c 372e 3235 2e32 3137 3930 3930 | 166...7.25.2179090
再查看下一條，這才是正常的：
Logdump 160 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 28 (x001c) IO Time : 2018/11/28 11:01:05.015.218
IOType : 15 (x0f) OrigNode : 255 (xff)
TransInd : . (x02) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 41516 AuditPos : 182935744
Continued : N (x00) RecCount : 1 (x01)
2018/11/28 11:01:05.015.218 FieldComp Len 28 RBA 4016967
Name: GS_YW.DJ_ZRRDA
After Image: Partition 4 G e
0001 0018 0000 0014 3230 3132 3131 3030 3030 3030 | ........201211000000
3234 3136 3434 3734 | 24164474
Column 1 (x0001), Len 24 (x0018)
0000 0014 3230 3132 3131 3030 3030 3030 3234 3136 | ....2012110000002416
3434 3734 | 4474
GGS tokens:
5200 0014 4141 4177 6a48 4141 4b41 4144 5033 4d41 | R...AAAwjHAAKAADP3MA
414c 0001 4601 0001 05 | AL..F....
明顯是報錯的rba記錄缺失欄位，在復制行程跳過這條rba之后又會有新的rba缺失欄位。
請問是我的操作有問題嗎...添加附加日志的姿勢不對？
求解，這幾次都是重新添加附加日志之后導致的問題，但是具體是哪里不對，就分析不出來了。
愁啊
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/57100.html
標籤：基礎和管理