您好,登錄后才能下訂單哦!
抽取進(jìn)程:
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進(jìn)程:
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
應(yīng)用進(jìn)程:
數(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進(jìn)程:
注意:一定要登錄到dblogin到目標(biāo)數(shù)據(jù)庫,否則提示要刪除checkpoint table
dblogin userid goldengate,password goldengate
stop rep_code
delete replicat rep_code
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。