一次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的复制进程报告文件显示如下结果：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>
Operation failed at seqno 249 rba 499263939
Discarding record on action DISCARD on error 8102
Problem replicating YXTX.ORDERTICKETS to YXTX.ORDERTICKETS
Mapping problem with delete record (target format)...
*
ORDERTICKETSID = 16235142
*
Current time: 2013-08-28 08:52:49
Operation failed at seqno 250 rba 97595277
Discarding record on action DISCARD on error 8102
Problem replicating YXTX.ORDERTICKETS to YXTX.ORDERTICKETS
Mapping problem with compressed update record (target format)...
*
ORDERTICKETSID = 16700914
ORDERID = T2013082418767
ORDLOGINNAME = TAOJUNJIE
ORDGOLDINFOID = Gold002231
ORDDETPNR = JNB8E2
ORDDETNEWPNR = NULL
ORDAIRCOMP = CA
ORDLINENUM = CA1559
ORDHOMEPORT = PEK
ORDDESTPORT = TAO
ORDPLANETYPE = 73K
ORDTICKETTYPE = 1
ORDAIRPORTFEE = 687.00
ORDPRICE = 797.00
ORDPOINT = NULL
ORDDISCOUNT = 2.60
ORDOILFEE = 60.00
ORDBULIT = 50.00
ORDOTHER = NULL
ORDBERTH = Y
ORDSTARTDAYTIME = 2013-08-26 08:45:56
ORDDATETIME = 2013-08-24 10:05:56
ORDABATE = 2013-08-24 10:05:56
ORDPAYTYPE = 2
ORDSTATE = 3
ORDLINKMAN = <Raw Data>
000000: d0 ed bd e0 |.... |
ORDTEL = 13505320012
ORDADD = <Raw Data>
000000: c9 bd b6 ab ca a1 c7 e0 b5 ba ca d0 |............ |
ORDEMAIL = junjiehangkong@126.com
ORDPRESID = CA008
ORDMEMO = <Raw Data>
000000: b4 cb bf cd c6 b1 c0 e0 d0 cd ce aa 42 53 50 a1 |............BSP.|
000010: a3 d3 c5 bb dd bc db b8 f1 b3 fd cd e2 2e 42 53 |..............BS|
000020: 50 c7 eb bc d3 c8 eb 43 54 43 54 cf ee 2e |P......CTCT... |
ORDDERATENO = NULL
ORDINSURANCE = 0
ORDMODIID = 196051
ORDMODIDATE = 2013-08-28 08:52:41
ORDTICOUTTIME = NULL
ORDGETTIME = 2013-08-28 08:52:41
ORDYEEPAYORDER = 2013082423802775
ORDYEEPAYDATE = 2013-08-24 10:08:24
ORDDELIVERADD = NULL
ORDDELIVERTIME = NULL
ORDARRDAYTIME = 2013-08-26 10:05:56
ORDIBEPRICE = 710.00
ORDNUM = 1
ORDTICKETAUTOTIC = 1
ORDYEEPAYDETAIL = Seller:Gold002231:798.33
ORDSPECID = 5707930
ORDJOURNEYPRINT = 0
ORDINCOME = NULL
ORDGOLDDIS = 100
ORDLOWCABIN = 0
ORDRETAINDIS = 0
ORDSTDPRICE = 710.00
ORDLOCAL = 0
ORDALLPRICE = 797.00
ORDRTNMEMO = NULL
ORDISSETTLEMENT = 0
ORDPAYPLATFORM = 3
ORDGATEID = NULL
ORDPROCTIME = 341058
ORDGETID = 196051
ORDGRETAINDIS = NULL
GBALTYPE = NULL
ORDFINCHECK = NULL
LOCKEDSTATE = U
ORDSECSTARTDAYTIME = NULL
ORDSECARRDAYTIME = NULL
ORDSECGOLDDIS = NULL
ORDB2GSTATE = NULL
ORDFROM = 1
ORDTYPE = 2
*
Current time: 2013-08-28 10:46:36
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>
Operation failed at seqno 250 rba 222023188
Discarding record on action DISCARD on error 8102
Problem replicating YXTX.ORDERTICKETS_HIS to YXTX.ORDERTICKETS_HIS
Mapping problem with delete record (target format)...
*
ORDERTICKETSID = 11128340
*
Current time: 2013-08-28 10:47:44
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>
Operation failed at seqno 250 rba 223336781
Discarding record on action DISCARD on error 8102
Problem replicating YXTX.ORDERTICKETS_HIS to YXTX.ORDERTICKETS_HIS
Mapping problem with delete record (target format)...
*
ORDERTICKETSID = 11135967
*
Current time: 2013-08-28 10:52:15
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>
Operation failed at seqno 250 rba 228551989
Discarding record on action DISCARD on error 8102
Problem replicating YXTX.ORDERTICKETS_HIS to YXTX.ORDERTICKETS_HIS
Mapping problem with delete record (target format)...
*
ORDERTICKETSID = 11153401
*
Current time: 2013-08-28 10:54:53进程都是正常运行状态，也没有其他报错，数据库也是正常的。
我这边是一对多的配置，另外一个target端的OGG进程报告文件，没有显示上述错误信息。。（另外一边没有添加函数索引）
我昨天还将target端的这个表rebuild 了一次，但还是还是继续报这个错误。。。 我晚上准备把进程停了，重新把这2个表同步一次，不知道能不能搞定 不要 rebuild
要 drop + create Maclean Liu(刘相兵 发表于 2013-8-28 15:42 static/image/common/back.gif
不要 rebuild
要 drop + create
好的，谢谢，晚上我试试 重建表后，报错继续，我删除一个 length() 函数索引，现在好像不包错误信息了。。。等待明天上班再看是否还是继续报错。。。
页:
[1]