logdump

最新推荐文章于 2021-02-19 21:29:40 发布

zhaojian1988

最新推荐文章于 2021-02-19 21:29:40 发布

阅读量622

点赞数

本文链接：https://blog.csdn.net/zhaojian1988/article/details/46505965

版权

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