完整的goldengate抽取、pump和replicate进程配置

发布时间：2020-12-12 13:45:45 所属栏目：百科来源：网络整理

导读：抽取进程： extract ext_code SETENV (NLS_LANG="AMERICAN_AMERICA.AL32UTF8") SETENV (ORACLE_HOME = "/app/oracle/product/10.2.0/db") SETENV (ORACLE_SID = chunqiu) userid [email?protected],password AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZH

抽取进程：
extract ext_code
SETENV (NLS_LANG="AMERICAN_AMERICA.AL32UTF8")
SETENV (ORACLE_HOME = "/app/oracle/product/10.2.0/db")
SETENV (ORACLE_SID = chunqiu)
userid [email?protected],password AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC,ENCRYPTKEY DEFAULT
exttrail ./dirdat/de
--tranlogoptions excludeuser goldengate
dynamicresolution
WARNLONGTRANS 3h,CHECKINTERVAL 30m
gettruncates
tranlogoptions altarchivelogdest +DG1/gbbarcode/archivelog/
TRANLOGOPTIONS ASMUSER [email?protected],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 [email?protected],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

应用进程：
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.checkpointstart rep_code,aftercsn 112892036392

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!