为提高效率,请提供以下信息,问题描述清晰能够更快得到解决:
源数据库: oracle 19c ogg Version 19.1.0.0.4
目标数据库: TIDB 4.0.XX OGG Version 19.1.0.0.3
安装及配置步骤参照 https://book.tidb.io/session4/chapter5/from-oracle-to-tidb.html
初始化数据报错
2021-05-10 17:57:46 WARNING OGG-03006 Source database character set or Target client character set is missing. OGG character set conversion is disabled.
2021-05-10 17:57:46 WARNING OGG-01004 Aborted grouped transaction on ymtx_ogg.mw_order_details, Database error 1366 ([SQL error 1366]incorrect utf8 value b0a2cef4c2e5cea4c8e9b8e0(������Τ
���) for column item_name
).
这个问题改如何处理。
extract init_ti
SETENV (ORACLE_HOME="/data/u01/app/oracle/product/19.3.0/dbhome_1")
setenv (NLS_LANG=“AMERICAN_AMERICA.ZHS16GBK”)
replicat rnit_ti
SETENV (NLS_LANG = AMERICAN_AMERICA.AL32UTF8)
targetdb ymtx_ogg@192.168.5.X1:4000 userid ogg password XXXXXX
discardfile /data/ogg/dirrpt/rnit_ti.dsc
map ymtx.mw_goods_class_history, target ymtx_ogg.mw_goods_class_history;
map ymtx.mw_goods_history, target ymtx_ogg.mw_goods_history;