12 积分	0 好友	1 主题

发消息

Goldengate rep进程abended

1^#

发表于 2013-1-14 15:56:56 | 查看: 9711| 回复: 8

本帖最后由 linfeng_oracle 于 2013-1-14 16:21 编辑

Oracle版本：10205rac
Goldengate版本：11.1

部分表没有pk或唯一索引。

因为客户需求，需要停节点一实例，停止步骤：先停ogg再停节点一，过了一小时，启动节点一，启动ogg，发现复制端数据不一致。

源端：
GGSCI (p570a) 4> view param mgr

port 7809
DYNAMICPORTLIST 7840-7850
purgeoldextracts  ./dirdat/*, usecheckpoints, minkeepdays 3
--userid goldengate, password goldengate

GGSCI (p570a) 3> view param EXTGZ

Extract extgz
USERID goldengate, PASSWORD AACAAAAAAAAAAALAPEOEEEHGSJSDOIQFABLGIGPDZDVJBJJB, ENCRYPTKEY default
tranlogoptions asmuser sys@asm1, asmpassword asm10g
warnlongtrans 12h, checkinterval 10m
BR BROFF
TRANLOGOPTIONS CONVERTUCS2CLOBS
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY  3000 IOLATENCY 3000
exttrail ./dirdat/gz
table GZGJJ3.*;
table GZGJJ.*;
table APP.*;
table DEV01.*;
table DEV02.*;
table goldengate.*;

GGSCI (p570a) 5> view param DPEGZ

extract dpegz
passthru
REPORT AT 01:59
reportrollover at 02:00
discardfile ./dirrpt/dpedm.dsc,append, megabytes 100
rmthost 172.16.155.4, mgrport 7809, compress
rmttrail ./dirdat/gz
dynamicresolution
table GZGJJ3.*;
table GZGJJ.*;
table APP.*;
table DEV01.*;
table DEV02.*;
table goldengate.*;

目标端：

GGSCI (rx8640a) 4> view param REPGZ

replicat repgz
setenv (ORACLE_SID = "gzgjj1")

USERID goldengate, PASSWORD AACAAAAAAAAAAALAPEOEEEHGSJSDOIQFABLGIGPDZDVJBJJB, ENCRYPTKEY default

REPORT AT 01:59
reportrollover at 02:00
sqlexec "Alter session set constraints=deferred"
assumetargetdefs
allownoopupdates
reperror default,abend
discardfile ./dirrpt/repgz.dsc, append, megabytes  100M
SHOWSYNTAX
batchsql
grouptransops 2000
dynamicresolution
allownoopupdates

map GZGJJ.GD_WF_SQSPYJ, target GZGJJ.GD_WF_SQSPYJ, keycols (SQBH);
obey ./dirsql/map_target.txt

BR BROFF有关系吗？

replog20130114.rar

151.17 KB, 下载次数: 1880

rep日志

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2013-1-14 15:59:41

rep端的dirrpt 打包上传

回复只看该作者道具举报

Maclean Liu(刘相兵

3^#

发表于 2013-1-14 16:32:41

2013-01-14 10:19:36 WARNING OGG-00869 Aborting BATCHSQL transaction. Detected inconsistent result: executed 1 operations in batch, resulting in 0 affected rows.
2013-01-14 10:19:36 WARNING OGG-01137 BATCHSQL suspended, continuing in normal mode.
2013-01-14 10:19:36 WARNING OGG-01003 Repositioning to rba 89158 in seqno 716.
2013-01-14 10:19:36 WARNING OGG-01004 Aborted grouped transaction on 'GZGJJ.GJJ_DWMX', Database error 1403 ().
2013-01-14 10:19:36 WARNING OGG-01003 Repositioning to rba 89158 in seqno 716.
2013-01-14 10:19:36 WARNING OGG-01154 SQL error 1403 mapping GZGJJ.GJJ_DWMX to GZGJJ.GJJ_DWMX.
2013-01-14 10:19:36 WARNING OGG-01003 Repositioning to rba 95607 in seqno 716.
Source Context :
SourceModule : [er.main]
SourceID : [/scratch/pradshar/view_storage/pradshar_bugdb_12826354/oggcore/OpenSys/src/app/er/rep.c]
SourceFunction : [take_rep_err_action]
SourceLine : [16064]
2013-01-14 10:19:36 ERROR OGG-01296 Error mapping from GZGJJ.GJJ_DWMX to GZGJJ.GJJ_DWMX.