求助:ogg 目标端replicat 进程不能正常应用 ,怎么解决?
源端的进程都正常
ogg 目标端进程 显示running, 但是一直都是延时,无法向前应用
GGSCI1> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REPCP1 37:29:13 00:31:14
REPLICAT RUNNING REPCP2 39:19:46 00:41:53
REPLICAT RUNNING REPCP3 00:01:04 40:03:37
配置参数如下:
REPORT AT 01:59
reportrollover at 02:00
discardrollover on friday
reperror default,abend
discardfile ./dirrpt/repcp1.dsc,append, megabytes 10
assumetargetdefs
allownoopupdates
dynamicresolution
numfiles 3000
insertappend
batchsql
maxtransops 5000
--grouptrans 5000
HANDLECOLLISIONS
查看ggserr.log 一直提示这个:
in seqno 366.
10:17:08WARNING OGG-00869Oracle GoldenGate Delivery for Oracle, repcp1.prm:Aborting BATCHSQL transaction. Detected inconsistent result: executed 2 operations in batch, resulting in 1 affected rows.
10:17:08WARNING OGG-01003Oracle GoldenGate Delivery for Oracle, repcp1.prm:Repositioning to rba 4883471 in seqno 368.
10:17:08WARNING OGG-01003Oracle GoldenGate Delivery for Oracle, repcp3.prm:Repositioning to rba 8340713 in seqno 366.
10:17:08WARNING OGG-01003Oracle GoldenGate Delivery for Oracle, repcp1.prm:Repositioning to rba 4883471 in seqno 368.
10:17:08WARNING OGG-00869Oracle GoldenGate Delivery for Oracle, repcp2.prm:Aborting BATCHSQL transaction. Detected inconsistent result: executed 10 operations in batch, resulting in 9 affected rows.
10:17:08WARNING OGG-00869Oracle GoldenGate Delivery for Oracle, repcp1.prm:Aborting BATCHSQL transaction. Detected inconsistent result: executed 2 operations in batch, resulting in 1 affected rows.
10:17:08WARNING OGG-01003Oracle GoldenGate Delivery for Oracle, repcp2.prm:Repositioning to rba 13476429 in seqno 366.
10:17:08WARNING OGG-01003Oracle GoldenGate Delivery for Oracle, repcp1.prm:Repositioning to rba 4883471 in seqno 368.
请问这个该怎么解决呢?
页:
[1]