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

抽取进程：
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