2024-02-23 14:54:49 ?INFO ? ?OGG-02756 ?從線索文件獲取了表 GISTAR.PXPH_PON_ROUTE 的定義。.
The following columns did not default because of type mismatches:
? id

OGG-00918 ?映射中缺少鍵列 id.

目標端有字段ID，由于mysql自增，所以只能是bigint類型，而源端是生產id字段為varchar2類型，無法修改。

2024-02-23 14:54:49  INFO    OGG-02756  從線索文件獲取了表 GISTAR.PXPH_PON_ROUTE 的定義。.
The following columns did not default because of type mismatches:id2024-02-23 14:54:49  INFO    OGG-06511  在默認映射中按名稱使用以下列： SPECLINENO, INNER_ORDER, A_RESOURCE_TYPE, A_RESOURCE_TYPE_ID, A_RESOURCE_CODE, A_RESOURCE_ID, A_MOD
ULE_CODE, A_MODULE_ID, A_SERIAL, A_SERIAL_ID, B_RESOURCE_TYPE, B_RESOURCE_TYPE_ID, B_RESOURCE_CODE, B_RESOURCE_ID, B_MODULE_CODE, B_MODULE_ID, B_SERIAL, B_SERIAL_ID, PHY_
CONNECT_TYPE, STATUS, IS_VIRTUAL_ROUTE, USE_STATUS, ENABLED_DATE, REMARK, SAP, AREACODE, BUREAUNO, BUSINESSAREAID, PHYSICALACCESSNBR, LOGICALACCESSNBR, IPADDRESS, EQUIPRO
OMID, MANAGEMENTIP.Source Context :SourceModule            : [er.mapping]SourceID                : [er/mapping.cpp]SourceMethod            : [get_map_entry]SourceLine              : [3446]ThreadBacktrace         : [16] elements: [/db/ogg/mysql/libgglog.so(CMessageContext::AddThreadContext())]: [/db/ogg/mysql/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]: [/db/ogg/mysql/libgglog.so(_MSG_ColumnName(CSourceContext*, int, ggs::gglib::ggapp::CDBObjName<(DBObjType)13> const&, CMessageFactory::Message
Disposition))]: [/db/ogg/mysql/replicat(get_map_entry(ggs::gglib::ggunicode::UString const&, int, wc_def*, ObjectMetadataRequest const&, unsigned int, unsigne
d int, ggs::gglib::ggmetadata::MetadataContext&, ggs::gglib::ggmetadata::TableManager&, unsigned int, ggs::gglib::ggmetadata::CTblMetadata*, ggs::gglib::ggmetadata::CMeta
dataReader*, bool, bool, bool))]: [/db/ogg/mysql/replicat(wc_def::resolve_wc_entry(ObjectMetadataRequest const&, int, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1>*, ggs::ggl
ib::ggmetadata::MetadataContext&, ggs::gglib::ggmetadata::TableManager&, ggs::gglib::ggmetadata::CTblMetadata*, ggs::gglib::ggmetadata::CMetadataReader*))]: [/db/ogg/mysql/replicat(WILDCARD_check_table(ObjectMetadataRequest const&, bool, bool, unsigned int, ggs::gglib::ggapp::CQualDBObjName<(DBObjT
ype)1>*, ggs::gglib::ggmetadata::TableManager&, ggs::gglib::ggmetadata::CTblMetadata*, ggs::gglib::ggmetadata::CMetadataReader*, bool, ggs::gglib::gglcr::CommonLCR*, bool
))]: [/db/ogg/mysql/replicat(ggs::er::ERContext::findSourceMetadata(ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, int, ggs::gglib::ggmeta
data::CTblMetadata*, ggs::gglib::ggmetadata::CMetadataReader*, bool))]: [/db/ogg/mysql/replicat(ggs::gglib::ggapp::ReplicationContext::sourceMetadataLookup(ggs::gglib::gglcr::CommonLCR const*))]: [/db/ogg/mysql/replicat(ggs::er::ReplicatContext::processReplicatLoop())]: [/db/ogg/mysql/replicat()]: [/db/ogg/mysql/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain())]: [/db/ogg/mysql/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]: [/db/ogg/mysql/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]: [/db/ogg/mysql/replicat(main)]: [/lib64/libc.so.6(__libc_start_main)]: [/db/ogg/mysql/replicat()]2024-02-23 14:54:49  ERROR   OGG-00918  映射中缺少鍵列 id.

原因是源端為varchar2,目標端是bigint，目標端復制進程增加函數轉換處理即可：

GGSCI (lnpg) 34> view param ir1replicat ir1
targetdb resdb@192.168.207.143, userid ogg, password xxx@
discardfile ./dirrpt/ir1.dsc,append,megabytes 1000
MAXTRANSOPS 5000
REPLACEBADCHAR ESCAPE
--map gistar.*, target resdb.*, colmap (id=@NUMSTR(id), usedefaults);
map gistar.pxph_pon_route       , target resdb.pxph_pon_route   , colmap (id=@NUMSTR(id), usedefaults)  ;

源端抽取進程如下：

GGSCI (lnpg) 123> view param i1extract i1
USERIDALIAS oracle11g
RMTHOST 192.168.207.143,MGRPORT 17809
RMTTASK REPLICAT,GROUP ir1table gistar.pxph_pon_route;

相關參考：Oracle GoldenGate實現實時數據過濾和數據轉換詳解-CSDN博客