抽取进程: extract ext_code SETENV (NLS_LANG="AMERICAN_AMERICA.AL32UTF8") SETENV (ORACLE_HOME = "/app/oracle/product/10.2.0/db") SETENV (ORACLE_SID = chunqiu) userid goldengate@chunqiu,password AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC, ENCRYPTKEY DEFAULT exttrail ./dirdat/de --tranlogoptions excludeuser goldengate dynamicresolution WARNLONGTRANS 3h, CHECKINTERVAL 30m gettruncates tranlogoptions altarchivelogdest +DG1/gbbarcode/archivelog/ TRANLOGOPTIONS ASMUSER SYS@ASM, ASMPASSWORD oracle table chunqiu.plm_acc_serial; table chunqiu.plm_acc_serial_tsc;
ADD EXTRACT ext_code,tranlog,BEGIN now ADD exttrail ./dirdat/de,EXTRACT ext_code,megabytes 200
pump进程: extract pum_code SETENV (NLS_LANG="AMERICAN_AMERICA.AL32UTF8") SETENV (ORACLE_HOME = "/app/oracle/product/10.2.0/db") SETENV (ORACLE_SID = chunqiu) userid goldengate@chunqiu,password AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC, ENCR YPTKEY DEFAULT rmthost 192.168.50.68, mgrport 7801 rmttrail ./dirdat/cc PASSTHRU gettruncates table chunqiu.plm_acc_serial; table chunqiu.plm_acc_serial_tsc;
ADD EXTRACT pum_code,exttrailsource ./dirdat/de ADD rmttrail ./dirdat/cc,EXTRACT pum_code,megabytes 200
应用进程: 数据库修改参数,11g之前不需要设置enable_goldengate_replication参数: alter system set enable_goldengate_replication=true scope=both;
数据库添加goldengate用户: create tablespace OGG_TBS datafile size 10G autoextend on next 100m maxsize unlimited; create user goldengate default tablespace OGG_TBS identified by goldengate; grant dba to goldengate ;
添加checkpoint表: dblogin userid goldengate,password goldengate add checkpointtable goldengate.checkpoint EDIT PARAMS ./GLOBALS CHECKPOINTTABLE goldengate.checkpoint
replicat rep_code
SETENV (NLS_LANG="AMERICAN_AMERICA.AL32UTF8")
userid goldengate,password goldengate
assumetargetdefs
reperror default,discard
discardfile /goldengate/rep_code.log,append,megabytes 1000
gettruncates
map chunqiu.PLM_ACC_SERIAL, target idc.PLM_ACC_SERIAL;
map chunqiu.PLM_ACC_SERIAL_TSC, target idc.PLM_ACC_SERIAL_TSC;
add replicat rep_code,exttrail ./dirdat/cc, checkpointtable goldengate.checkpoint start rep_code,aftercsn 112892036392
删掉replicat进程: 注意:一定要登录到dblogin到目标数据库,否则提示要删除checkpoint table dblogin userid goldengate,password goldengate stop rep_code delete replicat rep_code