Oracle goldengate ogg00869 ogg01431 ogg1003

最新推荐文章于 2025-03-28 14:58:28 发布

原创最新推荐文章于 2025-03-28 14:58:28 发布 · 1.5k 阅读

1 ·

CC 4.0 BY-SA版权

本文记录了一次在客户现场测试机上遇到的Oracle GoldenGate复制进程错误情况，并提供了详细的日志信息及解决步骤，包括停止并重启进程、调整数据库表结构等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

oracle goldengate 复制进程错误。

以下是我在客户现场测试机收集到的日志信息。

Opened trail file ./dirdat/ya000004 at 2017-05-11 18:19:18

MAP resolved (entry hong.w_user):
map "HONG"."W_USER",target hong.w_user,filter ( @getenv ("TRANSACTION", "CSN") > 6713995);

2017-05-11 18:19:18 WARNING OGG-00869 No unique key is defined for table 'W_USER'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Using following columns in default map by name:
ID, OPENID, INTIME, UPTIME, DEL, PHONE, TYPE, REMARK, SGROUP,
ACTIVITY_TIME
Using the following key columns for target table HONG.W_USER: ID, OPENID, INTIME, UPTIME, DEL, PHONE, TYPE, REMARK, SGROUP, ACTIVITY_TIME.

2017-05-11 18:24:50 WARNING OGG-01431 Aborted grouped transaction on 'HONG.W_USER', Mapping error.

2017-05-11 18:24:50 WARNING OGG-01003 Repositioning to rba 2402 in seqno 4.

2017-05-11 18:24:50 WARNING OGG-01151 Error mapping from HONG.W_USER to HONG.W_USER.

2017-05-11 18:24:50 WARNING OGG-01003 Repositioning to rba 2402 in seqno 4.

Source Context :
SourceModule : [er.errors]
SourceID : [/scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/app/er/errors.cpp]
SourceFunction : [take_rep_err_action]
SourceLine : [623]
ThreadBacktrace : [8] elements
: [/ogg/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f7a8997c06e]]
: [/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2cc) [0x7f7a8997844c]]
: [/ogg/libgglog.so(_MSG_ERR_MAP_TO_TANDEM_FAILED(CSourceContext*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, CMessageFactory::Me
ssageDisposition)+0x53) [0x7f7a89970f19]]
: [/ogg/replicat(take_rep_err_action(short, int, char const*, extr_ptr_def*, __std_rec_hdr*, char*, file_def*, bool)+0xdac) [0x51daa0]]
: [/ogg/replicat(process_extract_loop()+0x2240) [0x536ab0]]
: [/ogg/replicat(main+0x732) [0x548752]]
: [/lib64/libc.so.6(__libc_start_main+0xfd) [0x35a101ed5d]]
: [/ogg/replicat(__gxx_personality_v0+0x322) [0x4be48a]]

2017-05-11 18:24:50 ERROR OGG-01296 Error mapping from HONG.W_USER to HONG.W_USER.

解决方式：

登录源端：

stop ext 进程。

dblogin user username,password password

delete trandata username.tablename

add trandata username.tablename

登录数据库：

sqlplus / as sysdba

alter table hong.w_user add xxxxxxxxx 增加主键。

目标端：

alter replicat repya,seqno xxxxx,extrba nnnnn