----------------------------------------------------------------------------------------------------------------
Source Database:
GGSCI (ogg1) 46> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DUMP1 00:00:00 00:00:05
EXTRACT RUNNING EXT1 00:00:00 00:00:08
GGSCI (ogg1) 47> view params mgr
port 7809
DYNAMICPORTLIST 7810-7820
autorestart extract *, retries 5, waitminutes 3
purgeoldextracts ./dirdat/*,usecheckpoints, minkeepdays 10
userid ogg,password ogg
EXT:
GGSCI (ogg1) 48> view params ext1
extract ext1
setenv ( NLS_LANG = AMERICAN_AMERICA.AL32UTF8 )
userid ogg, password ogg
REPORT AT 01:59
reportrollover at 02:00
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 3000 IOLATENCY 3000
TRANLOGOPTIONS DBLOGREADER,DBLOGREADERBUFSIZE 4096000
TRANLOGOPTIONS BUFSIZE 10000000
discardfile ./dirrpt/ext1.dsc,append,megabytes 10
exttrail ./dirdat/ee
numfiles 3000
dynamicresolution
STATOPTIONS REPORTFETCH
FETCHOPTIONS SUPPRESSDUPLICATES
table sun.DEPT1;
table sun.EMP1;
table sun.TABLES1;
table sun.INDEXES1;
table sun.test;
DUMP:
GGSCI (ogg1) 50> view params dump1
extract dump1
setenv ( NLS_LANG = AMERICAN_AMERICA.AL32UTF8 )
userid ogg, password ogg
REPORT AT 01:59
reportrollover at 02:00
RMTHOST 10.0.2.12, MGRPORT 7809
RMTTRAIL /ogg/ogghome/dirdat/ee
DYNAMICRESOLUTION
numfiles 3000
table sun.DEPT1;
table sun.EMP1;
table sun.TABLES1;
table sun.INDEXES1;
table sun.test;
-----------------------------------------------------------------------------------------------------------------------------------------
Remote Database:
GGSCI (ogg1) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP1 00:00:00 00:00:08
MGR:
GGSCI (ogg1) 5> view params mgr
port 7809
DYNAMICPORTLIST 7810-7820
autorestart extract *, retries 5, waitminutes 3
purgeoldextracts ./dirdat/*,usecheckpoints, minkeepdays 10
userid ogg,password ogg
REP:
GGSCI (ogg1) 7> view params rep1
REPLICAT rep1
setenv ( NLS_LANG = AMERICAN_AMERICA.AL32UTF8 )
USERID ogg,PASSWORD ogg
SQLEXEC "ALTER SESSION SET CONSTRAINTS=DEFERRED"
REPORT AT 01:59
REPORTROLLOVER AT 02:00
REPERROR DEFAULT,DISCARD
HANDLECOLLISIONS
DISCARDFILE ./dirrpt/rep1.dsc,PURGE
DISCARDROLLOVER AT 02:00
GETTRUNCATES
ASSUMETARGETDEFS
DYNAMICRESOLUTION
ALLOWNOOPUPDATES;
map sun.*, target sun.*;