NNING DPE_EXT2 00:00:00 00:00:05
EXTRACT RUNNING EXT1 00:00:00 00:00:00
EXTRACT RUNNING EXT2 00:00:00 00:00:03
EXTRACT RUNNING EXT_DEMO 00:00:00 00:00:09
GGSCI (oratest) 46>
抽取进程：
GGSCI (oratest) 48> edit params EXT2
EXTRACT ext2
userid goldengate,password goldengate
REPORTCOUNT EVERY 1 MINUTES, RATE
numfiles 5000
DISCARDFILE ./dirrpt/ext2.dsc,APPEND,MEGABYTES 1000
DISCARDROLLOVER AT 3:00
exttrail ./dirdat/r3,megabytes 100
ddl include all
TRANLOGOPTIONS DBLOGREADER
TABLE OGG1.*;
SEQUENCE OGG1.*;
~
"dirprm/ext2.prm" 11L, 284C written
GGSCI (oratest) 49> stop ext2
Sending STOP request to EXTRACT EXT2 ...
Request processed.
GGSCI (oratest) 50> start ext2
Sending START request to MANAGER ...
EXTRACT EXT2 starting
GGSCI (oratest) 51> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DPE_DEMO 00:00:00 00:00:07
EXTRACT RUNNING DPE_EXT2 00:00:00 00:00:02
EXTRACT RUNNING EXT1 00:00:00 00:00:06
EXTRACT RUNNING EXT2 00:00:03 00:00:07
EXTRACT RUNNING EXT_DEMO 00:00:00 00:00:05
GGSCI (oratest) 52>
提前修改该文件：
修改文件：
GGSCI (oratest) 79> EDIT PARAMS ./GLOBALS
GGSCHEMA goldengate
~
FLUSH SEQUENCE ogg1.*
重启更加有效果！
|