OGG同步字符集从US7ASCII to ZHS16GBK故障解决
系统环境
源端:
aix 5.3
oracle 9.2.0.7 for rac
IP 192.168.124.1
ogg 11.1.1.1.2
字符集 US7ASCII
目标端:
Red hat 6.5
oracle 11.2.0.4
iP 192.168.17.188
Ogg 12.1.2.1.0
字符集 ZHS16GBK
1.初始化(略)
注意:1.使用exp/imp初始化 需要手动修改DMP文件头字符集为ZHS16GBK。
2.如果使用SCN导入导出错,可以不用SCN而直接配合handlecollisions参数保证数据正确
3.嫌exp/imp初始化麻烦可以使用OGG直接初始化
2.源端配置以操作
GGSCI (GCQ_FWSK_DB_01) 97> view params ex1
extract ex1
exttrail /backup/ex
setenv (NLS_LANG=AMERICAN_AMERICA.US7ASCII)
userid oggadmin,password oggadmin123
gettruncates
reportcount every 30 minutes,rate
--setenv (NLS_LANG = AMERICAN_AMERICA.US7ASCII)
tranlogoptions ,dblogreaderbufsize 524288
eofdelay 3
tranlogoptions bufsize 524288
flushsecs 3
tranlogoptions logretention disabled
discardfile dirrpt/ex1.dsc,append,megabytes 1024
discardrollover AT 3:00
warnlongtrans 2h,checkinterval 3m
dynamicresolution
dboptions allowunusedcolumn
fetchoptions nousesnapshot
fetchoptions fetchpkupdatecols
--tranlogoptions convertucs2clobs
--threadoptions maxcommitpropagationdelay 60000 iolatency 60000
table htjs.cb_czrz;
GGSCI (GCQ_FWSK_DB_01) 98> view params dp1
extract dp1
userid oggadmin,password oggadmin123
rmthost 192.168.17.188,mgrport 7809,compress
passthru
numfiles 5000
dynamicresolution
rmttrail dirdat/rx
table htjs.cb_czrz;
GGSCI (GCQ_FWSK_DB_01) 89> start ex1
Sending START request to MANAGER ...
EXTRACT EX1 starting
GGSCI (GCQ_FWSK_DB_01) 90> info all
Program Status
系统环境
源端:
aix 5.3
oracle 9.2.0.7 for rac
IP 192.168.124.1
ogg 11.1.1.1.2
字符集 US7ASCII
目标端:
Red hat 6.5
oracle 11.2.0.4
iP 192.168.17.188
Ogg 12.1.2.1.0
字符集 ZHS16GBK
1.初始化(略)
注意:1.使用exp/imp初始化 需要手动修改DMP文件头字符集为ZHS16GBK。
2.如果使用SCN导入导出错,可以不用SCN而直接配合handlecollisions参数保证数据正确
3.嫌exp/imp初始化麻烦可以使用OGG直接初始化
2.源端配置以操作
GGSCI (GCQ_FWSK_DB_01) 97> view params ex1
extract ex1
exttrail /backup/ex
setenv (NLS_LANG=AMERICAN_AMERICA.US7ASCII)
userid oggadmin,password oggadmin123
gettruncates
reportcount every 30 minutes,rate
--setenv (NLS_LANG = AMERICAN_AMERICA.US7ASCII)
tranlogoptions ,dblogreaderbufsize 524288
eofdelay 3
tranlogoptions bufsize 524288
flushsecs 3
tranlogoptions logretention disabled
discardfile dirrpt/ex1.dsc,append,megabytes 1024
discardrollover AT 3:00
warnlongtrans 2h,checkinterval 3m
dynamicresolution
dboptions allowunusedcolumn
fetchoptions nousesnapshot
fetchoptions fetchpkupdatecols
--tranlogoptions convertucs2clobs
--threadoptions maxcommitpropagationdelay 60000 iolatency 60000
table htjs.cb_czrz;
GGSCI (GCQ_FWSK_DB_01) 98> view params dp1
extract dp1
userid oggadmin,password oggadmin123
rmthost 192.168.17.188,mgrport 7809,compress
passthru
numfiles 5000
dynamicresolution
rmttrail dirdat/rx
table htjs.cb_czrz;
GGSCI (GCQ_FWSK_DB_01) 89> start ex1
Sending START request to MANAGER ...
EXTRACT EX1 starting
GGSCI (GCQ_FWSK_DB_01) 90> info all
Program Status