EXTRACT
GGSCI (zbdba1) 1> dblogin userid ogg,password ogg GGSCI (zbdba1) 1> add trandata zbdba.* GGSCI (zbdba1) 65> REGISTER EXTRACT ext1 DATABASE 2015-03-03 21:57:13 WARNING OGG-01758 This EXTRACT EXT1 is already registered with the database. GGSCI (zbdba1) 2> ADD EXTRACT ext1 INTEGRATED TRANLOG, BEGIN NOW EXTRACT added. GGSCI (zbdba1) 3> GGSCI (zbdba1) 3> GGSCI (zbdba1) 3> add exttrail /ogg/dirdat/sa extract ext1 EXTTRAIL added. GGSCI (zbdba1) 4> add rmttrail ./dirdat/sa,extract ext1 RMTTRAIL added. GGSCI (zbdba1) 22> view param ext1 EXTRACT EXT1 setenv ( NLS_LANG = AMERICAN_AMERICA.ZHS16GBK ) USERID ogg,PASSWORD ogg DDL & INCLUDE MAPPED OBJTYPE 'TABLE' & INCLUDE MAPPED OBJTYPE 'IDNEX' & INCLUDE MAPPED OBJTYPE 'SEQUENCE' & INCLUDE MAPPED OBJTYPE 'VIEW' & INCLUDE MAPPED OBJTYPE 'PROCEDURE' & INCLUDE MAPPED OBJTYPE 'FUNCTION' & INCLUDE MAPPED OBJTYPE 'PACKAGE' & INCLUDE MAPPED OBJTYPE 'MATERIALIZED VIEW' & EXCLUDE OPTYPE COMMENT TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 100) DDLOPTIONS ADDTRANDATA NOCROSSRENAME REPORT REPORTCOUNT EVERY 1 MINUTES,RATE DISCARDFILE ./dirrpt/EXTSA.DSC,APPEND,MEGABYTES 1024 THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 60000 IOLATENCY 60000 DBOPTIONS ALLOWUNUSEDCOLUMN WARNLONGTRANS 2H,CHECKINTERVAL 3M exttrail ./dirdat/sa FETCHOPTIONS NOUSESNAPSHOT,FETCHPKUPDATECOLS,MISSINGROW REPORT table zbdba.*;
在设置TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 100) 参数时，启动可能报错
修改streams_pool_size的大小：
SQL> show parameter streams NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ streams_pool_size big integer 152M
开启ext1：
GGSCI (zbdba1) 13> start ext1 Sending START request to MANAGER ... EXTRACT EXT1 starting
查看日志：
2015-03-03 22:00:34 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 starting.
2015-03-03 22:00:34 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, ext1.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2015-03-03 22:00:34 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, ext1.prm: BOUNDED RECOVERY: reset to initial or altered checkpoint.
2015-03-03 22:00:34 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg/BR/EXT1.
2015-03-03 22:00:34 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg/dirtmp.
2015-03-03 22:00:35 WARNING OGG-01423 Oracle GoldenGate Capture for Oracle, ext1.prm: No valid default archive log destination directory found for thread 1.
2015-03-03 22:00:47 INFO OGG-02036 Oracle GoldenGate Capture for Oracle, ext1.prm: Integrated capture successfully attached to logmining server OGG$EXT1.
2015-03-03 22:00:48 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 started.
2015-03-03 22:00:48 INFO OGG-01056 Oracle GoldenGate Capture for Oracle, ext1.prm: Recovery initialization completed for target file ./dirdat/sa000000, at RBA 81396296, CSN 1296687.
2015-03-03 22:00:48 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ext1.prm: Output file