|
源端的进程都正常
ogg 目标端进程 显示running, 但是一直都是延时,无法向前应用
GGSCI1> info all
Program Status Group Lag at Chkpt Time 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:08 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repcp1.prm: Aborting BATCHSQL transaction. Detected inconsistent result: executed 2 operations in batch, resulting in 1 affected rows.
10:17:08 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repcp1.prm: Repositioning to rba 4883471 in seqno 368.
10:17:08 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repcp3.prm: Repositioning to rba 8340713 in seqno 366.
10:17:08 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repcp1.prm: Repositioning to rba 4883471 in seqno 368.
10:17:08 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repcp2.prm: Aborting BATCHSQL transaction. Detected inconsistent result: executed 10 operations in batch, resulting in 9 affected rows.
10:17:08 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repcp1.prm: Aborting BATCHSQL transaction. Detected inconsistent result: executed 2 operations in batch, resulting in 1 affected rows.
10:17:08 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repcp2.prm: Repositioning to rba 13476429 in seqno 366.
10:17:08 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repcp1.prm: Repositioning to rba 4883471 in seqno 368.
请问这个该怎么解决呢?
|
|