maomao 发表于 2014-3-19 10:18:23

求助: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]
查看完整版本: 求助:ogg 目标端replicat 进程不能正常应用 ,怎么解决?