OGG进程参数事例

----------------------------------------------------------------------------------------------------------------

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    

MGR：

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.*;