OGG 加源端进程

--加源端进程：
--extract
ADD EXTRACT EXTA, TRANLOG, BEGIN 2012-11-21 00:01:00
ADD EXTTRAIL ./dirdat/ea, EXTRACT EXTA, MEGABYTES 200

ADD EXTRACT EXTB, TRANLOG, BEGIN 2012-11-21 00:01:00
ADD EXTTRAIL ./dirdat/eb, EXTRACT EXTB, MEGABYTES 200

ADD EXTRACT EXTC, TRANLOG, BEGIN 2012-11-21 00:01:00
ADD EXTTRAIL ./dirdat/ec, EXTRACT EXTC, MEGABYTES 200

ADD EXTRACT EXTGP, TRANLOG, BEGIN now
ADD EXTTRAIL ./dirdat/gp, EXTRACT EXTGP, MEGABYTES 200

--pump
add extract pmpa, exttrailsource ./dirdat/ea
add rmttrail ./dirdat/pa, extract pmpa, MEGABYTES 200

add extract pmpb, exttrailsource ./dirdat/eb
add rmttrail ./dirdat/pb, extract pmpb, MEGABYTES 200

add extract pmpc, exttrailsource ./dirdat/ec
add rmttrail ./dirdat/pc, extract pmpc, MEGABYTES 200

add extract pmpgp, exttrailsource ./dirdat/gp
add rmttrail ./dirdat/pg, extract pmpgp, MEGABYTES 200

--加目标端进程：
add replicat repa01, exttrail ./dirdat/pa, checkpointtable goldengate.ggschkpt
add replicat repa02, exttrail ./dirdat/pa, checkpointtable goldengate.ggschkpt
add replicat repa03, exttrail ./dirdat/pa, checkpointtable goldengate.ggschkpt
add replicat repa04, exttrail ./dirdat/pa, checkpointtable goldengate.ggschkpt
add replicat repa05, exttrail ./dirdat/pa, checkpointtable goldengate.ggschkpt
add replicat repa06, exttrail ./dirdat/pa, checkpointtable goldengate.ggschkpt

add replicat repb01, exttrail ./dirdat/pb, checkpointtable goldengate.ggschkpt
add replicat repb02, exttrail ./dirdat/pb, checkpointtable goldengate.ggschkpt
add replicat repb03, exttrail ./dirdat/pb, checkpointtable goldengate.ggschkpt
add replicat repb04, exttrail ./dirdat/pb, checkpointtable goldengate.ggschkpt
add replicat repb05, exttrail ./dirdat/pb, checkpointtable goldengate.ggschkpt
add replicat repb06, exttrail ./dirdat/pb, checkpointtable goldengate.ggschkpt

add replicat repc01, exttrail ./dirdat/pc, checkpointtable goldengate.ggschkpt
add replicat repc01_1, exttrail ./dirdat/pc, checkpointtable goldengate.ggschkpt
add replicat repc01_2, exttrail ./dirdat/pc, checkpointtable goldengate.ggschkpt

add replicat repa01_1, exttrail ./dirdat/pa, checkpointtable goldengate.ggschkpt

--启动目标端进程：
start repa01, aftercsn 4419857798
start repa02, aftercsn 4419857798
start repa03, aftercsn 4419857798
start repa04, aftercsn 4419857798
start repa05, aftercsn 4419857798
start repa06, aftercsn 4419857798

start repb01, aftercsn 4419857798
start repb02, aftercsn 4419857798
start repb03, aftercsn 4419857798
start repb04, aftercsn 4419857798
start repb05, aftercsn 4419857798
start repb06, aftercsn 4419857798

start repc01, aftercsn 4419857798
start repc01_1, aftercsn 4419857798
start repc01_2, aftercsn 4419857798

start repa01_1, aftercsn 4419857798

源端：添加抽取进程
add extract extdac, tranlog, begin now
--ADD EXTRACT CAP6, TRANLOG, BEGIN 2010-11-08 16:00  
--ADD EXTRACT CAP7, TRANLOG, EXTSEQNO 15(一定要保证抽取进程在SCN之前启动)
add exttrail /exp/ggs/dirdat/dac/ex, extract extdac
--delete rmttrail /exp/ggs/dirdat/dac/re
GGSCI> ADD EXTRACT ext01, TRANLOG, BEGIN NOW
GGSCI> ADD EXTTRAIL ./dirdat/gt, EXTRACT ext01, MEGABYTES 200

edit params extdac
--checkparams
extract extdac
userid gg,password gg
tranlogoptions asmuserAACAAAAAAAAAAADAZCTHZIQBDIEAIHLI,encryptkey default
exttrail /exp/ggs/dirdat/dac/ex
discardfile ./dirrpt/extdac.dsc,append, megabytes 100
gettruncates
table cpdds_pdata.PUB_JNL_SAV;

start extdac
info all
info extdac detail
view report extdac

源端：添加传输进程
add extract pumpdac, exttrailsource /exp/ggs/dirdat/dac/ex
add rmttrail /exp/ggs/dirdat/dac/re, extract PUMPDAC

GGSCI> ADD EXTRACT dpegt, EXTTRAILSOURCE ./dirdat/gt
GGSCI> ADD RMTTRAIL ./dirdat/gt, EXTRACT dpegt, MEGABYTES 200

edit params pumpdac
extract pumpdac
rmthost dc02, mgrport 7809
passthru
rmttrail /exp/ggs/dirdat/dac/re
table cpdds_pdata.PUB_JNL_SAV;

start PUMPDAC
info all

源端数据库：
sqlplus cpdds_pdata/cpdds_pdata
alter session set nls_date_format='yyyymmdd hh24:mi:ss';
select min(START_TIME) from v$transaction;
select sysdate from dual;
select to_char(dbms_flashback.get_system_change_number,99999999999999999999999999) from dual;

expdp cpdds_pdata/cpdds_pdata tables=PUB_JNL_SAV directory=dpdir dumpfile=dump_%U.dmp filesize=4000m parallel=4 flashback_scn=12035272641452

目标数据库：
impdp cpdds_pdata/cpdds_pdata tables=PUB_JNL_SAV TABLE_EXISTS_ACTION=truncate directory=dpdir dumpfile=dump_%U.dmp parallel=4

对于数据量不大的小表，可以直接使用network_link直接导入而不生成dmp文件
--create public link link_name connect to username indentified by password using 'connect_strint';
--impdp system/oracle NETWORK_LINK=db75 tables=(qxy1.tab1,qxy1.tab2) flashback_scn=665218 TABLE_EXISTS_ACTION=truncate

 

加目标端进程：
add replicat repdac, exttrail /exp/ggs/dirdat/dac/re, checkpointtable dac_chkpt

edit params repdac

replicat repdac
assumetargetdefs
userid ggt,password ggt
discardfile ./dirrpt/repdac.dsc,append,megabytes 100
gettruncates
map cpdds_pdata.PUB_JNL_SAV, target cpdds_pdata.PUB_JNL_SAV;
启动进程：
start repdac, aftercsn 12035272641452