?做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) ;

?

goldengate 簡單配置 oracle to oralce