oracle to mysql的gg配置

源端操作：
GGSCI (100) 2> view param e_test

EXTRACT e_test
USERID gg, PASSWORD xxxx
gettruncates
RMTHOST 192.168.1.101, MGRPORT 7809
RMTTRAIL ./dirdat/ph

table xxxx.zgp;

add extract e_test tranlog, begin now

add rmttrail ./dirdat/ph, extract e_test, megabytes 20

 

GGSCI (y100) 3> view param o_test

DEFSFILE ./dirdef/o_test.def
USERID gg, PASSWORD xxxx

table yiqifa_bs_88.zgp;

./defgen paramfile ./dirrpm/o_test

將生成的o_test.def 拷貝多目標端。

目標端：
GGSCI (host112) 2> view param r_test

replicat r_test
SOURCECHARSET ZHS16GBK
sourcedefs /data/ggs_mysql/dirdef/o_test.def
targetdb test@127.0.0.1:3306,userid root, password xxxx                  
reperror default,abend
discardfile /data/ggs_mysql/r_test.dsc,append,megabytes 10

map xxxx.zgp, target test.zgp;

add replicat r_test  exttrail  ./dirdat/ph, nodbcheckpoint

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/20625855/viewspace-1110366/，如需轉載，請註明出處，否則將追究法律責任。