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