Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.0.0 Build 078
Linux, x64, 64bit (optimized), Oracle 11 on Jul 28 2010 13:13:42
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
GGSCI (vzwc1) 1> create subdirs
Creating subdirectories under current directory /ggs/ogg
Parameter files /ggs/ogg/dirprm: created
Report files /ggs/ogg/dirrpt: created
Checkpoint files /ggs/ogg/dirchk: created
Process status files /ggs/ogg/dirpcs: created
SQL script files /ggs/ogg/dirsql: created
Database definitions files /ggs/ogg/dirdef: created
Extract data files /ggs/ogg/dirdat: created
Temporary files /ggs/ogg/dirtmp: created
Veridata files /ggs/ogg/dirver: created
Veridata Lock files /ggs/ogg/dirver/lock: created
Veridata Out-Of-Sync files /ggs/ogg/dirver/oos: created
Veridata Out-Of-Sync XML files /ggs/ogg/dirver/oosxml: created
Veridata Parameter files /ggs/ogg/dirver/params: created
Veridata Report files /ggs/ogg/dirver/report: created
Veridata Status files /ggs/ogg/dirver/status: created
Veridata Trace files /ggs/ogg/dirver/trace: created
Stdout files /ggs/ogg/dirout: created
--配置mgr
GGSCI (vzwc1) 3> edit params mgr
GGSCI (vzwc1) 4> view params mgr
PORT 7809
DYNAMICPORTLIST 7840-7914
USERID goldengate, PASSWORD goldengate
AUTORESTART EXTRACT *,RETRIES 3,WAITMINUTES 5,RESETMINUTES 10
PURGEOLDEXTRACTS ./dirdat/*,usecheckpoints, minkeepdays 1
PURGEDDLHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5
PURGEMARKERHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45
GGSCI (vzwc1) 5> start mgr
Manager started.
GGSCI (vzwc1) 6> info mgr
Manager is running (IP port vzwc1.7809).
GGSCI (vzwc1) 40> dblogin userid ggadmin, password ggadmin
Successfully logged into database.
GGSCI (vzwc1) 41> add trandata scott.*
2014-02-15 23:14:50 WARNING OGG-00869 No unique key is defined for table BONUS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Logging of supplemental redo data enabled for table SCOTT.BONUS.
Logging of supplemental redo data enabled for table SCOTT.DEPT.
Logging of supplemental redo data enabled for table SCOTT.EMP.
2014-02-15 23:14:52 WARNING OGG-00869 No unique key is defined for table SALGRADE. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Logging of supplemental redo data enabled for table SCOTT.SALGRADE.
GGSCI (vzwc1) 43> list tables scott.*
SCOTT.BONUS
SCOTT.DEPT
SCOTT.EMP
SCOTT.SALGRADE
Found 4 tables matching list criteria.
--配置启动extract、pump、rmttrail
GGSCI (vzwc1) 1> dblogin userid ggadmin, password ggadmin
Successfully logged into database.
GGSCI (vzwc1) 7> add extract sora, tranlog, threads 2, begin now
EXTRACT added.
GGSCI (vzwc1) 8> ADD EXTTRAIL ./dirdat/ea, EXTRACT SORA
EXTTRAIL added.
GGSCI (vzwc1) 9> edit params sora
GGSCI (vzwc1) 10> view params SORA
EXTRACT SORA
USERID GGADMIN, PASSWORD ggadmin
EXTTRAIL ./dirdat/ea
TRANLOGOPTIONS RAWDEVICEOFFSET 0
REPORTCOUNT EVERY 1 MINUTES, RATE
DISCARDFILE ./dirrpt/exta.dsc,APPEND,MEGABYTES 1024
FETCHOPTIONS NOUSESNAPSHOT
ThreadOptions MaxCommitPropagationDelay 10000 IOLatency 3000
TRANLOGOPTIONS _INFINITYTOZERO
TRANLOGOPTIONS ASMUSER sys@a