一、mysql数据库初始化


1、source端配置


ADD EXTRACT EINI1, SOURCEISTABLE


EDIT PARAMS EINI1



EXTRACT EINI1


sourcedb test@localhost:3306,USERID root, PASSWORD xifenfei


RMTHOST 192.168.1.111, MGRPORT 7808


RMTTASK REPLICAT, GROUP RINI1


TABLE "test.web_statistics";


3、target端配置


ADD REPLICAT RINI1, SPECIALRUN


EDIT PARAMS RINI1



REPLICAT RINI1


ASSUMETARGETDEFS


DBOPTIONS HOST 127.0.0.1, CONNECTIONPORT 3306


TARGETDB test,userid root,password xifenfei


DISCARDFILE ./dirrpt/RINI2.dsc, PURGE


MAP "test.web_statistics", TARGET "test.web_statistics";


3、开启复制


start extract eini1


二、oracle数据库


1、source端配置


ADD EXTRACT EINI1, SOURCEISTABLE


EDIT PARAMS EINI1



EXTRACT EINI1


SETENV (NLS_LANG =AMERICAN_AMERICA.UTF8)


USERID ogg, PASSWORD "xifenfei"


RMTHOST 192.168.1.111, MGRPORT 7809


RMTTASK REPLICAT, GROUP RINI1


TABLE chf.init_obj;


2、target端配置


ADD REPLICAT RINI1, SPECIALRUN


EDIT PARAMS RINI1



REPLICAT RINI1


ASSUMETARGETDEFS


SETENV (NLS_LANG =AMERICAN_AMERICA.UTF8)


USERID ogg, PASSWORD xifenfei


DISCARDFILE ./dirrpt/RINI1.dsc, PURGE


MAP chf.init_obj, TARGET chf.init_obj;


3、开启复制


start extract eini1


oracle视频教程请关注:http://u.youku.com/user_video/id_UMzAzMjkxMjE2.html