Oracle Technology: Goldedgate Initialization data

First, MySQL database initialization

1. Source-side configuration

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-side configuration

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.

More Wonderful content: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

MAP "Test.web_statistics", TARGET "Test.web_statistics";

3. Turn on replication

Start Extract Eini1

Second, Oracle Database

1. Source-side configuration

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-side configuration

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. Turn on replication

Start Extract Eini1

Author: 51cto Oracle small-mixed son