goldengate简单配置oracle to oralce
goldengate简单配置oracle to oralce
做oracle时配置的，goldengate 是同步异构数据库最好的工具。这个是基于oracle to oracle 单向复制
添加增量复制进程 add extract process
--
-- Extract parameter file to capture
--
EXTRACT EIEX_EF
SETENV (NLS_LANG="AMERICAN_AMERICA.AL32UTF8")
SETENV (ORACLE_SID=erpdb)
userid system@erpdb, PASSWORD erpadmin
TRANLOGOPTIONS ASMUSER SYS@ASM, ASMPASSWORD oracle
EXTTRAIL ./dirdat/ef
TABLE erp_f.*;
TABLEEXCLUDE erp_f.ps_txn
修改后
--
-- Extract parameter file to capture
--
EXTRACT EIEX_EF
SETENV (NLS_LANG="AMERICAN_AMERICA.AL32UTF8")
SETENV (ORACLE_SID=erpdb)
userid system@erpdb, PASSWORD erpadmin
TRANLOGOPTIONS ASMUSER SYS@ASM, ASMPASSWORD oracle
EXTTRAIL ./dirdat/ef
TABLE erp_f.t00f0040;
TABLE erp_f.t00f0041；
TABLE erp_f.t00f0042；
TABLE erp_f.t00f0044；
目标端 target 端
REPLICAT REPDM
SETENV (NLS_LANG="AMERICAN_AMERICA.AL32UTF8")
SETENV (ORACLE_SID=erpdb)
handlecollisions
SOURCEDEFS /oracle/GGfromdb2/dirdef/tbdm.def
USERID erp_k@erpdb, PASSWORD kpre
MAP db.tbdm01, TARGET erp_k.T00kn002, reperror (1403, ignore) ;
MAP db.tbdm02, TARGET erp_k.T00kn006, reperror (1403, ignore) ;
