某公司Ogg参数配置记录

某公司ogg原端单节点目标Oracle rac asm 参数配置：
GGSCI (YhjCwDb1) 2> view params mgr


PORT 7800
DYNAMICPORTLIST 7840-8850
AUTOSTART ER *
AUTORESTART EXTRACT *,RETRIES 3,WAITMINUTES 5,RESETMINUTES 30
PURGEOLDEXTRACTS ./dirdat/1h* , USECHECKPOINTS, MINKEEPDAYS 3
LAGREPORTHOURS 1
LAGINFOMINUTES 30


GGSCI (YhjCwDb1) 6> view params ext_1h


extract ext_1h
setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
userid goldengate,password goldengate
GETTRUNCATES
REPORTCOUNT EVERY 3 MINUTES, RATE
DISCARDFILE ./dirrpt/ext1h.dsc,APPEND,MEGABYTES 1024
DBOPTIONS  ALLOWUNUSEDCOLUMN
BR BRINTERVAL 2H
WARNLONGTRANS 2h,CHECKINTERVAL 3m
FETCHOPTIONS NOUSESNAPSHOT
FETCHOPTIONS FETCHPKUPDATECOLS
TRANLOGOPTIONS convertucs2clobs
dynamicresolution
exttrail ./dirdat/1h
tableexclude LCXYHJ9999.TEMP*;
tableexclude LCXYHJ9999.TMP*;
table LCXYHJ9999.*;




GGSCI (YhjCwDb1) 3> view params pump_1h


extract pump_1h
setenv (NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")
passthru
report at 01:59
reportrollover at 02:00
rmthost 10.1.2.82,mgrport 7809,compress
rmttrail ./dirdat/1h/1h
dynamicresolution
table LCXYHJ9999.*;




GGSCI (db02) 2> view params rep_1h


replicat rep_1h
SETENV (ORACLE_SID="oradb2")
setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
userid ggm, password oracle
sqlexec "Alter session set constraints=deferred"
REPORT AT 01:59
reportrollover at 02:00
dynamicresolution
numfiles 800
assumetargetdefs
ALLOWNOOPUPDATES
GETUPDATEBEFORES
reperror default, abend
discardfile ./dirrpt/rp1h.dsc,append, megabytes  800M
map LCXYHJ9999.LSSTRU2009, target yihangju.LSSTRU2009;