完整的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;

創(chuàng)新互聯(lián)建站專注于洱源企業(yè)網(wǎng)站建設(shè),響應式網(wǎng)站開發(fā),成都做商城網(wǎng)站。洱源網(wǎng)站建設(shè)公司,為洱源等地區(qū)提供建站服務。全流程按需定制，專業(yè)設(shè)計，全程項目跟蹤，創(chuàng)新互聯(lián)建站專業(yè)和態(tài)度為您提供的服務

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

應用進程：
數(shù)據(jù)庫修改參數(shù)，11g之前不需要設(shè)置enable_goldengate_replication參數(shù)：
alter system set enable_goldengate_replication=true scope=both;

數(shù)據(jù)庫添加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到目標數(shù)據(jù)庫,否則提示要刪除checkpoint table
dblogin userid goldengate,password goldengate
stop rep_code
delete replicat rep_code

當前名稱：完整的goldengate抽取、pump和replicate進程配置
網(wǎng)站地址：http://bm7419.com/article36/pccdsg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供企業(yè)建站、App開發(fā)、用戶體驗、服務器托管、響應式網(wǎng)站、App設(shè)計

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)