OGG配置同步报错OGG-06441

原创伟鹏 2023-10-24

1287

在配置oracle到oracle的ogg同步初始化完成之后
启动ogg进程，有报错如下：
2023-04-26 09:56:12 INFO OGG-30067 Opened trail file /data/oracle/ogg/dirdat/oa000000432, RBA: 22,338,965 at 2023-04-26 09:56:12.111875.
2023-04-26 09:56:12 INFO OGG-03506 The source database character set, as determined from the trail file, is UTF-8.
2023-04-26 09:56:12 WARNING OGG-02760 ASSUMETARGETDEFS is ignored because trail file /data/oracle/ogg/dirdat/oa000000432 contains table definitions.
2023-04-26 09:56:12 INFO OGG-06505 MAP resolved (entry ECOLOGY.MOBILEAPPBASEINFO): MAP “ECOLOGY”.“MOBILEAPPBASEINFO”, TARGET ECOLOGY.MOBILEAPPBASEINFO.
2023-04-26 09:56:12 WARNING OGG-06441 Unique key M_FORMMODELAPPID_UINDEX for table MOBILEAPPBASEINFO cannot be used due to the inclusion of virtual columns, nullable
columns, user-defined datatypes, extended long varchar columns, or function-based index columns.
2023-04-26 09:56:12 INFO OGG-02756 The definition for table ECOLOGY.MOBILEAPPBASEINFO is obtained from the trail file.
2023-04-26 09:56:12 INFO OGG-06511 Using following columns in default map by name: ID, APPNAME, PICPATH, DESCRIPTIONS, SHOWORDER, ISDELETE, FORMID, ISPUBLISH, MOD
ELID, PUBLISHID, HASHEADER, SKIN, SUBCOMPANYID, CREATEDATE, MODIFYDATE, CREATOR, CATEGORY, ECVERSION, BADGECONFIG, CUBEAPPID, FORMMODELAPPID, NOLOGINENABLED, NOLOGINUS
ER.
2023-04-26 09:56:12 INFO OGG-06510 Using the following key columns for target table ECOLOGY.MOBILEAPPBASEINFO: ID, APPNAME, PICPATH, DESCRIPTIONS, SHOWORDER, ISDE
LETE, FORMID, ISPUBLISH, MODELID, PUBLISHID, HASHEADER, SKIN, SUBCOMPANYID, CREATEDATE, MODIFYDATE, CREATOR, CATEGORY, ECVERSION, BADGECONFIG, FORMMODELAPPID, NOLOGINE
NABLED, NOLOGINUSER.
2023-04-26 09:56:12 WARNING OGG-01431 Canceled grouped transaction on ECOLOGY.MOBILEAPPBASEINFO, Mapping error.
2023-04-26 09:56:12 WARNING OGG-01003 Repositioning to rba 22340897 in seqno 432.
2023-04-26 09:56:12 WARNING OGG-01151 Error mapping from ECOLOGY.MOBILEAPPBASEINFO to ECOLOGY.MOBILEAPPBASEINFO.
#####################

Replicat Abended With Error OGG-01169 Encountered an update where all key columns for target table

are not present, INFO OGG-01451 Unique key cannot be used due to the inclusion of virtual columns (Doc ID 1578985.1)

GoldenGate 需要在目标表中指定一个唯一键（Unique Key），以便在复制过程中进行数据匹配和一致性维护

从报错信息来看，因为包含了virtual columns导致Unique key不能用，这个的情况下我们需要用keycols在目标端指定一列来进行数据的匹配

处理过程：
1、查看唯一索引对应的列

在源端执行如下sql，查看该唯一索引创建语句：

select dbms_metadata.get_ddl(‘INDEX’,‘M_FORMMODELAPPID_UINDEX’,‘ECOLOGY’) from dual;

2、查看创建语句
CREATE UNIQUE INDEX “ECOLOGY”.“M_FORMMODELAPPID_UINDEX” ON “ECOLOGY”.“MOBILEAPPBASEINFO” (“FORMMODELAPPID”)
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE “ECOLOGY”

3、将这个加入到map里面
MAP ECOLOGY.MOBILEAPPBASEINFO, TARGET ECOLOGY.MOBILEAPPBASEINFO,KEYCOLS(FORMMODELAPPID);

4、启动ogg服务，进程正常

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

OGG配置同步报错OGG-06441

评论