一次OGG同步异常

杨飞

target端系统：linux 红帽 5.4  64位版本
target端数据库：oracle 10.2.0.4.0  64位
target端OGG： Oracle® GoldenGate 11g Release 1 Patch Set 1 (11.1.1.1.1)

问题：
       以为有一个复杂的多表查询中，有一些函数条件，所以我在target端的数据库中，添加了一些函数索引（2个）。添加完函数索引之后，问题来了。

target端OGG的复制进程报告文件显示如下结果：

1. OCI Error ORA-08102: index key not found, obj# 69730, file 10, block 3297270 (2) (status = 8102), SQL <DELETE FROM "YXTX"."ORDERTICKETS"  WHERE "ORDERTICKETSID" = :b0>
   
2. Operation failed at seqno 249 rba 499263939
   
3. Discarding record on action DISCARD on error 8102
   
4. Problem replicating YXTX.ORDERTICKETS to YXTX.ORDERTICKETS
   
5. Mapping problem with delete record (target format)...
   
6. *
   
7. ORDERTICKETSID = 16235142
   
8. *
   
9. Current time: 2013-08-28 08:52:49
   
10. 
    
11. Operation failed at seqno 250 rba 97595277
    
12. Discarding record on action DISCARD on error 8102
    
13. Problem replicating YXTX.ORDERTICKETS to YXTX.ORDERTICKETS
    
14. Mapping problem with compressed update record (target format)...
    
15. *
    
16. ORDERTICKETSID = 16700914
    
17. ORDERID = T2013082418767
    
18. ORDLOGINNAME = TAOJUNJIE
    
19. ORDGOLDINFOID = Gold002231
    
20. ORDDETPNR = JNB8E2
    
21. ORDDETNEWPNR = NULL
    
22. ORDAIRCOMP = CA
    
23. ORDLINENUM = CA1559
    
24. ORDHOMEPORT = PEK
    
25. ORDDESTPORT = TAO
    
26. ORDPLANETYPE = 73K
    
27. ORDTICKETTYPE = 1
    
28. ORDAIRPORTFEE = 687.00
    
29. ORDPRICE = 797.00
    
30. ORDPOINT = NULL
    
31. ORDDISCOUNT = 2.60
    
32. ORDOILFEE = 60.00
    
33. ORDBULIT = 50.00
    
34. ORDOTHER = NULL
    
35. ORDBERTH = Y
    
36. ORDSTARTDAYTIME = 2013-08-26 08:45:56
    
37. ORDDATETIME = 2013-08-24 10:05:56
    
38. ORDABATE = 2013-08-24 10:05:56
    
39. ORDPAYTYPE = 2
    
40. ORDSTATE = 3
    
41. ORDLINKMAN = <Raw Data>
    
42. 000000: d0 ed bd e0                                     |....            |
    
43. ORDTEL = 13505320012
    
44. ORDADD = <Raw Data>
    
45. 000000: c9 bd b6 ab ca a1 c7 e0 b5 ba ca d0             |............    |
    
46. ORDEMAIL = junjiehangkong@126.com
    
47. ORDPRESID = CA008
    
48. ORDMEMO = <Raw Data>
    
49. 000000: b4 cb bf cd c6 b1 c0 e0 d0 cd ce aa 42 53 50 a1 |............BSP.|
    
50. 000010: a3 d3 c5 bb dd bc db b8 f1 b3 fd cd e2 2e 42 53 |..............BS|
    
51. 000020: 50 c7 eb bc d3 c8 eb 43 54 43 54 cf ee 2e       |P......CTCT...  |
    
52. ORDDERATENO = NULL
    
53. ORDINSURANCE = 0
    
54. ORDMODIID = 196051
    
55. ORDMODIDATE = 2013-08-28 08:52:41
    
56. ORDTICOUTTIME = NULL
    
57. ORDGETTIME = 2013-08-28 08:52:41
    
58. ORDYEEPAYORDER = 2013082423802775
    
59. ORDYEEPAYDATE = 2013-08-24 10:08:24
    
60. ORDDELIVERADD = NULL
    
61. ORDDELIVERTIME = NULL
    
62. ORDARRDAYTIME = 2013-08-26 10:05:56
    
63. ORDIBEPRICE = 710.00
    
64. ORDNUM = 1
    
65. ORDTICKETAUTOTIC = 1
    
66. ORDYEEPAYDETAIL = Seller:Gold002231:798.33
    
67. ORDSPECID = 5707930
    
68. ORDJOURNEYPRINT = 0
    
69. ORDINCOME = NULL
    
70. ORDGOLDDIS = 100
    
71. ORDLOWCABIN = 0
    
72. ORDRETAINDIS = 0
    
73. ORDSTDPRICE = 710.00
    
74. ORDLOCAL = 0
    
75. ORDALLPRICE = 797.00
    
76. ORDRTNMEMO = NULL
    
77. ORDISSETTLEMENT = 0
    
78. ORDPAYPLATFORM = 3
    
79. ORDGATEID = NULL
    
80. ORDPROCTIME = 341058
    
81. ORDGETID = 196051
    
82. ORDGRETAINDIS = NULL
    
83. GBALTYPE = NULL
    
84. ORDFINCHECK = NULL
    
85. LOCKEDSTATE = U
    
86. ORDSECSTARTDAYTIME = NULL
    
87. ORDSECARRDAYTIME = NULL
    
88. ORDSECGOLDDIS = NULL
    
89. ORDB2GSTATE = NULL
    
90. ORDFROM = 1
    
91. ORDTYPE = 2
    
92. *
    
93. Current time: 2013-08-28 10:46:36
    
94. 
    
95. OCI Error ORA-08102: index key not found, obj# 69867, file 9, block 3147844 (2) (status = 8102), SQL <DELETE FROM "YXTX"."ORDERTICKETS_HIS"  WHERE "ORDERTICKETSID" = :b0>
    
96. Operation failed at seqno 250 rba 222023188
    
97. Discarding record on action DISCARD on error 8102
    
98. Problem replicating YXTX.ORDERTICKETS_HIS to YXTX.ORDERTICKETS_HIS
    
99. Mapping problem with delete record (target format)...
    
100. *
     
101. ORDERTICKETSID = 11128340
     
102. *
     
103. Current time: 2013-08-28 10:47:44
     
104. 
     
105. OCI Error ORA-08102: index key not found, obj# 69867, file 9, block 3147844 (2) (status = 8102), SQL <DELETE FROM "YXTX"."ORDERTICKETS_HIS"  WHERE "ORDERTICKETSID" = :b0>
     
106. Operation failed at seqno 250 rba 223336781
     
107. Discarding record on action DISCARD on error 8102
     
108. Problem replicating YXTX.ORDERTICKETS_HIS to YXTX.ORDERTICKETS_HIS
     
109. Mapping problem with delete record (target format)...
     
110. *
     
111. ORDERTICKETSID = 11135967
     
112. *
     
113. Current time: 2013-08-28 10:52:15
     
114. 
     
115. OCI Error ORA-08102: index key not found, obj# 69867, file 9, block 3147844 (2) (status = 8102), SQL <DELETE FROM "YXTX"."ORDERTICKETS_HIS"  WHERE "ORDERTICKETSID" = :b0>
     
116. Operation failed at seqno 250 rba 228551989
     
117. Discarding record on action DISCARD on error 8102
     
118. Problem replicating YXTX.ORDERTICKETS_HIS to YXTX.ORDERTICKETS_HIS
     
119. Mapping problem with delete record (target format)...
     
120. *
     
121. ORDERTICKETSID = 11153401
     
122. *
     
123. Current time: 2013-08-28 10:54:53

复制代码

进程都是正常运行状态，也没有其他报错，数据库也是正常的。

我这边是一对多的配置，另外一个target端的OGG进程报告文件，没有显示上述错误信息。。（另外一边没有添加函数索引）

我昨天还将target端的这个表rebuild 了一次，但还是还是继续报这个错误。。。

杨飞

我晚上准备把进程停了，重新把这2个表同步一次，不知道能不能搞定

Maclean Liu(刘相兵

不要 rebuild

要 drop + create

杨飞

Maclean Liu(刘相兵 发表于 2013-8-28 15:42
不要 rebuild

要 drop + create

好的，谢谢，晚上我试试

杨飞

重建表后，报错继续，我删除一个 length() 函数索引，现在好像不包错误信息了。。。等待明天上班再看是否还是继续报错。。。