ORACLE SOS

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索
查看: 5681|回复: 0

求助:ogg 目标端replicat 进程不能正常应用 ,怎么解决?

[复制链接]

1

主题

1

帖子

5

积分

新手上路

Rank: 1

积分
5
发表于 2014-3-19 10:18:23 | 显示全部楼层 |阅读模式

源端的进程都正常
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.

请问这个该怎么解决呢?


回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|Archiver|手机版|ORACLE SOS 技术论坛

GMT+8, 2024-12-5 10:22 , Processed in 0.018164 second(s), 20 queries .

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表