goldedgate 初始化数据

 

一、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

 

 

（以上内容摘于网络，如有侵权，请告之，将第一时间删除）