oracle 忘记账号 密码怎么办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_LAoracle账号NG="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) ;