1:管理进程参数
-- edit param mgr
PORT 7950
DYNAMICPORTLIST 7950-7990
-- AUTOSTART *
AUTORESTART EXTRACT *, WAITMINUTES 2, RETRIES 5
LAGREPORTHOURS 1
LAGINFOMINUTES 1
LAGCRITICALMINUTES 5
PURGEOLDEXTRACTS ./dirdat/*,USECHECKPOINTS, MINKEEPDAYS 3
2:抽取进程参数
EXTRACT sextr01
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
SETENV (ORACLE_SID=orcl)
USERID ogguser,PASSWORD ogguser
DYNAMICRESOLUTION
gettruncates
report at 1:59
reportrollover at 2:00
warnlongtrans 3h, checkinterval 10m
TRANLOGOPTIONS RAWDEVICEOFFSET 0
EXTTRAIL ./dirdat/VH
TABLE ODS_TEST.I_ARC_R_PLAN;
TABLE ODS_TEST.I_PRE_BAL_QT;
TABLE ODS_TEST.XTBILL2013;
TABLE ODS_TEST.T_JJ_DTGCJD;
2:添加抽取进程
add extract sextr01,tranlog,begin now
add exttrail ./dirdat/VH,extract sextr01
3:投递进程参数
EXTRACT spump01
passthru
DYNAMICRESOLUTION
RMTHOST 192.168.1.15, MGRPORT 7950, COMPRESS
RMTTRAIL ./dirdat/VH
TABLE ODS_TEST.*;
4:添加投递进程
add extract spump01,EXTTRAILSOURCE ./dirdat/VH
add rmttrail ./dirdat/VH,EXTRACT spump01, megabytes 100
5:复制进程参数
REPLICAT TREPLVH
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
SETENV (ORACLE_SID=orcl)
USERID ogguser, PASSWORD ogguser
ASSUMETARGETDEFS
GETTRUNCATES
report at 1:59
reportrollover at 2:00
reperror default,abend
ALLOWNOOPUPDATES
DISCARDFILE ./dirrpt/discard_VH.dsc, PURGE
MAP ODS_TEST.I_ARC_R_PLAN, TARGET ODS_TEST1.I_ARC_R_PLAN;
MAP ODS_TEST.I_PRE_BAL_QT, TARGET ODS_TEST1.I_PRE_BAL_QT;
MAP ODS_TEST.XTBILL2013, TARGET ODS_TEST1.XTBILL2013 , COLMAP (USEDEFAULTS, updatetime=@DATENOW());
--handlecollisions
MAP ODS_TEST.T_JJ_DTGCJD, TARGET ODS_TEST1.T_JJ_DTGCJD;
6:添加复制进程
add replicat TREPLVO1, exttrail ./dirdat/V0, NODBCHECKPOINT |
|