- 最后登录
- 2018-11-1
- 在线时间
- 377 小时
- 威望
- 29
- 金钱
- 6866
- 注册时间
- 2011-10-12
- 阅读权限
- 200
- 帖子
- 891
- 精华
- 4
- 积分
- 29
- UID
- 1
|
1#
发表于 2012-12-17 13:34:02
IOType: for a list of record types, see the Logdump chapter of the GoldenGate for Windows
and UNIX Reference Guide. Or issue the Logdump command SHOW RECTYPE.
If the primary key is part of the update, both a before and after image will be saved. The
IOType will be 115 (primary key update).
Logdump 6 >[oracle@mlab1 ogg]$ logdump
Oracle GoldenGate Log File Dump Utility for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Logdump 6 >show rectype
LogTrail record types
1 - Abort 2 - Commit
3 - Delete 4 - EndRollBack
5 - Insert 6 - Prepared
7 - TMF-Shutdown 8 - TransBegin
9 - TransRelease 10 - Update
11 - UpdateComp 12 - FileAlter
13 - FileCreate 14 - FilePurge
15 - FieldComp 16 - FileRename
17 - AuxPointer 18 - NetworkCommit
19 - NetworkAbort 20 - CurrentPos
90 - GGSSQLCol 100 - GGSPurgedata
108 - GGSPurgedataPartonly 101 - GGSPurgeFile
102 - GGSCreateFile 103 - GGSAlterFile
104 - GGSRenameFile 105 - GGSSetmode
107 - GGSControl 106 - GGSChangeLabel
115 - GGSPKUpdate 117 - GGSPKUpdate32
116 - LargeObject 132 - Sequence OP
150 - RestartAbend 151 - RestartOK
152 - RecoveryEnd 160 - DDLOP
161 - RecordFragment 200 - GGSBulkio
201 - GGSFileClose 202 - GGSLoggerTS
203 - GGSExtractTS 204 - GGSCollectTS
205 - GGSComment 250 - LibOpenTrace
251 - LibCloseTrace 252 - LoggerOpenTrace
253 - LoggerCloseTrace 254 - LoggerAddedInfo
249 - LoggerAddedStats 255 - FileHeader
iotype 15 =>FieldComp =>Number of non-primary key updates
|
|