GoldenGate -- filetoreplicat initializes Oracle Data to MySQL

Initialize oracle Data to mysql. Use oracletomysl to map oracle data types to mysql Data Types and modify the data types to make mysql available.

Initialize oracle Data to mysql. Use oracle to mysl to map oracle data types to mysql Data Types and modify the data types to make mysql available.

Initialize Oracle Data to mysql. Use the oracle to mysl tool to map oracle data types to mysql Data Types and modify them accordingly so that mysql can accommodate the length of oracle fields, this document executes the initial data and does not copy the data. It only imports the data and the oracle database at the source end is static. If the data is not static, You need to configure the extraction process and application process.

1. Edit mgr Parameters
Source

Edit param mgr

PORT 7819
DYNAMICPORTLIST 7820-7840
Autorestart extract *, RETRIES 5, WAITMINUTES 2, RESETMINUTES 10
-- PURGEOLDEXTRACTS/data/goldengate/dirdat/*, USECHECKPOINTS, MINKEEPDAYS 3
-- Purgeddlhistory minkeepdays 7, maxkeepdays 10
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45

Target

Edit param mgr

PORT 7819
DYNAMICPORTLIST 7820-7840
Autorestart extract *, RETRIES 5, WAITMINUTES 2, RESETMINUTES 10
-- PURGEOLDEXTRACTS/data/goldengate/dirdat/*, USECHECKPOINTS, MINKEEPDAYS 3
-- Purgeddlhistory minkeepdays 7, maxkeepdays 10
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45

2. Start mgr
Source
Start mgr
Info all
Target
Start mgr
Info all

3. Edit the initialization process

The initialization process does not need to be started.

Source

Edit param extinit


SOURCEISTABLE
Setenv (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8 ")
Userid goldengate, password goldengate
RMTHOST 10.58.8.26, MGRPORT 7819
RMTFILE/data/goldengate/rmtfile 5000, MEGABYTES 1024
Scott .*;

Target

Edit param repinit
SPECIALRUN
END RUNTIME
Setenv (NLS_LANG = AMERICAN_AMERICA.AL32UTF8)
Dboptions host 127.0.0.1, CONNECTIONPORT 3306
TARGETDB testdb, userid root, password root_password

EXTFILE/data/goldengate/rmtfile
Assumetargetdefs
MAP scott. *, TARGET testdb .*;

--- A problem may occur here. You can use dblogin to test whether the user can log on to the mysql database. The error/tmp/scok may be reported because mysql is compiled and installed manually ,, this file does not exist in tmp. Create a file in tmp and ln the sock file in the real installation directory.

4. Start Initialization
Source
Cd/data/goldengate/
/Data/goldengate/extract paramfile dirprm/extinit. prm reportfile dirrpt/extinit. rpt

Target
Cd/data/goldengate/
/Data/goldengate/replicat paramfile dirprm/repinit. prm reportfile dirrpt/repinit. rpt