软件下载:https://edelivery.oracle.com/EPD/WelcomePage/get_form?ARU_LANG=ZHS
c:\ggs>logdump
Oracle GoldenGate Log File Dump Utility
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
Logdump 1 >open C:\ggs\dirdat\pt000002
Current LogTrail is C:\ggs\dirdat\pt000002
Logdump 2 >pos 1438
Reading forward from RBA 1438
Logdump 3 >n
Logdump 4 >help
FC [<num> | <string>] - Edit previous command
HISTORY - List previous commands
OPEN | FROM <filename> - Open a Log file
RECORD | REC - Display audit record
NEXT [ <count> ] - Display next data record
SKIP [ <count> ] [FILTER] - Skip down <count> records
FILTER - Apply filter during skip
COUNT - Count the records in the file
[START[time] <timestr>,]
[END[time] <timestr>,]
[INT[erval] <minutes>,]
[LOG[trail] <wildcard-template>,]
[FILE <wildcard-template>,]
[DETAIL ]
<timestr> format is
[[yy]yy-mm-dd] [hh[:mm][:ss]]
POSITION [ <rba> | FIRST | LAST | EOF ] - Set position in file
REVerse | FORward - Set read direction
RECLEN [ <size> ] - Sets max output length
EXIT | QUIT - Exit the program
FILES | FI | DIR - Display filenames
ENV - Show current settings
VOLUME | VOL | V - Change default volume
DEBUG - Enter the debugger
GHDR ON | OFF - Toggle GHDR display
DETAIL ON | OFF | DATA - Toggle detailed data display
RECLEN <nnn> - Set data display length
SCANFORHEADER (SFH) [PREV] - Search for the start of a header
SCANFORTYPE (SFT) - Find the next record of <TYPE>
<typename> | <typenumber>
[,<filename-template>]
SCANFORRBA (SFR) - Find the next record with <SYSKEY>
<syskey> - syskey = -1 scans for next record
,<filename-template>
SCANFORTIME (SFTS) - Find the next record with timestamp
<date-time string>
[,<filename-template>]
<date-time string> format is
[[yy]yy-mm-dd] [hh[:mm][:ss]]
SCANFORENDTRANS (SFET) - Find the end of the current transaction
SCANFORNEXTTRANS (SFNT) - Find start of the next transaction
SHOW <option> - Display internal information
[OPEN] - list open files
[TIME] - print current time in various formats
[ENV] - show current environment
[RECTYPE] - show list of record types
[FILTER] - show active filter items
BIO <option> - Set LargeBlock I/O info
[ON] - Enable LargeBlock I/O (default)
[OFF] - Disable LargeBlock I/O
[BLOCK <nnnn>]- Set LargeBlock I/O size
TIMEOFFSET <option> - Set the time offset from GMT
[LOCAL] - Use local time
[GMT] - Use GMT time
[GMT +/- hh[:mm]] - Offset +/- from GMT
FILTER SHOW
FILTER ENABLE | ON - Enable filtering
FILTER DISABLE | OFF - Disable filtering
FILTER CLEAR [ <filterid> | <ALL> ]
FILTER MATCH ANY | ALL
FILTER [INClude | EXCLude] <filter options>
<filter options> are
RECTYPE <type number | type name>
STRING [BOTH] /<text>/ [<column range>]
HEX <hex string> [<column range>]
TRANSID <TMF transaction identifier>
FILENAME <filename template>
PROCESS <processname template>
INT16 <16-bit integer>
INT32 <32-bit integer>
INT64 <64-bit integer>
STARTTIME <date-time string>
ENDTIME <date-time string>
SYSKEY [<comparison>] <32/64-bit syskey>
SYSKEYLEN [<comparison>] [<value>]
TRANSIND [<comparison>] <nn>
UNDOFLAG [<comparison>] <nn>
RECLEN [<comparison>] <nn>
AUDITRBA [<comparison>] <nnnnnnnn>
ANSINAME <ansi table name>
GGSTOKEN <tokenname> [<comparison>] [<tokenvalue>]
USERTOKEN <tokenname> [<comparison>] [<tokenvalue>]
CSN | LogCSN [<comparison>] [<value>]
<column range>
<start column>:<end column>, ie 0:231
<comparison>
=, ==, !=, <>, <, >, <=, >= EQ, GT, LE, GE, LE, NE
X <program> [string] - Execute <program>
TRANSHIST nnnn - Set size of transaction history
TRANSRECLIMIT nnnn - Set low record count threshold
TRANSBYTELIMIT nnnn - Set low byte count threshold
LOG {STOP} | { [TO] <filename> } - Write a session log
BEGIN <date-time> - Set next read position using a timestamp
SAVEFILECOMMENT on | OFF - Toggle comment records in a savefile
SAVE <savefilename> [!] <options> - Write data to a savefile
<options> are
nnn RECORDS | nnn BYTES
[NOCOMMENT] - Suppress the Comment header/trailer recs, Default
[COMMENT] - Insert Comment header/trailer recs
[OLDFORMAT] - Force oldformat records
[NEWFORMAT] - Force newformat records
[TRUNCATE ] - purgedata an existing savefile
[EXT ( <pri>, <sec> [,<max>])] - Savefile Extent sizes on NSK
[MEGabytes <nnnn>] - For extent size calculation
[TRANSIND <nnn>] - Set the transind field
[COMMITTS <nnn>] - Set the committs field
USERTOKEN on | OFF | detail - Show user token info
HEADERTOKEN on | OFF | detail - Show header token info
GGSTOKEN on | OFF | detail - Show GGS token info
FILEHEADER on | OFF | detail - Display file header contents
ASCIIHEADER ON | off - Toggle header charset
EBCDICHEADER on | OFF - Toggle header charset
ASCIIDATA ON | on - Toggle user data charset
EBCDICDATA on | OFF - Toggle user data charset
ASCIIDUMP ON | off - Toggle charset for hex/ascii display
EBCDICDUMP on | OFF - Toggle charset for hex/ascii display
TRAILFORMAT old | new - Force trail type
PRINTMXCOLUMNINFO on | OFF - Toggle SQL/MX columninfo display
TMFBEFOREIMAGE on | OFF - Toggle display of TMF before images
FLOAT <value> - Interpret a floating point number
[FORMAT <specifier>] - sprintf format default %f
Logdump 9 >pos 1438
Reading forward from RBA 1438
Logdump 10 >n
2012/10/17 17:12:46.195.969 Insert Len 28 RBA 1438
Name: 000.TEST1
After Image: Partition 4 G s
0000 0006 0000 0002 3431 0001 000e 0000 000a 7464 | ........41........td
6164 6473 3333 3363 | adds333c
Logdump 17 >n
Logdump 18 >pos 1577
Reading forward from RBA 1577
Logdump 19 >n
2012/10/17 17:14:35.182.695 FieldComp Len 26 RBA 1577
Name: 000.TEST1
After Image: Partition 4 G s
0000 0004 ffff 0000 0001 000e 0000 000a 6165 6674 | ................aeft
7474 6173 6466 | ttasdf
Logdump 20 >count
** Count begins at RBA 1577
LogTrail C:\ggs\dirdat\pt000002 has 1 records
Total Data Bytes 26
Avg Bytes/Record 26
FieldComp 1
After Images 1
Average of 1 Transactions
Bytes/Trans ..... 74
Records/Trans ... 1
Files/Trans ..... 1
Logdump 21 >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
Logdump 22 >scanforendtrans
End of Transaction found at RBA 1577
2012/10/17 17:14:35.182.695 FieldComp Len 26 RBA 1577
Name: 000.TEST1
After Image: Partition 4 G s
0000 0004 ffff 0000 0001 000e 0000 000a 6165 6674 | ................aeft
7474 6173 6466 | ttasdf
Logdump 23 >detail on
Logdump 24 >
Hdr-Ind: 该值总是E,表示是extract process创建,如果为其他属性,则表示不可用。
UndoFlag:该属性正常值为0,当为1时则表示先前已经成功的记录进行撤销操作。
这里我不清楚是不是指这种情况:例如一个大事务未commit的情况,数据已经写入
到redo中,而ogg是读取redo进行同步的,在ogg抽取数据以后这个事务又被rollback了。
RecLength:record buffer长度,单位是bytes
IOType:表示操作类型,该属性有如下几种值:
3 - Delete
5 - Insert
10 - Update(full record)
15 - Update(compressed record)
TransInd:事务记录标志,有如下4种可能属性;
x00 - start of transaction
x01 - middle of transaction
x02 - end of transaction
x03 - only record in transaction
SyskeyLen:system key长度。如果system key存在,其第一个bytes表示system key记录,否则该值为0.
AuditRBA:事务record commit地址,同一个事务中,该值均相同。goldengate通过auditRBA+IO Time来确定
一个事务,其值是唯一的。
Continued:该属性有两种值:Y和N,用来定义数据片大大小,通常lob,clob或varchar类型,该值是Y,否则是N。
Partition:该属性是goldengate内部使用的一个标示,并不是指os或数据库层面的逻辑分区和物理分区。windows和unix
平台下,该属性值总是为4。
对于Nonstop的记录,该属性的值取决于如下两个方面:
1)存在Bulk IO操作的情况下,该值表示源端分区已经完成的bulk IO操作的数量。其取值范围为0~15.
2)对于其他非bulk io操作的nonstop record情况下,该属性取值通常为0或4. 为4的情况,表示该数据为
FiledComp record格式 (compress存储格式)。
BeforeAfter: 对于update操作,表示该数据是before image还是after image。对于insert操作,总是after images,
而delete操作总是before images。
IO Time:记录提交时间,同一个事务内的所有记录,该属性值都是相同的,为GMT格式。
OrigNode:Nonstop情况下,表示extract数据抽取端的节点号,整个cluster内,每个节点的节点号都是唯一的。
该属性取值范围是0~255. 除nonstop之外的其他情况,该属性值为0.
FormatType:表示数据是从事务日志读取还是直接从数据库中获取的。取值为F和R,F表示fetched from database。
R表示readable in transaction log。
Incomplete:该属性值从10.4版本就已经废弃了,是向前兼容保留的。
AuditPos: 标示extract process在transaction log中的位置。
RecCount:在windows和unix平台下,ogg处理lob时,是将其split成chunk,然后将chunk写入到file中。
recCount用来表示在读取时对chunk的合并。
对于logdump 看到的record 记录,其实iotype也就4种,3,5,10,15. 其中15表示compress record。
那么如何启用record的压缩存储呢?其实有个参数控制的,那就是auditcompress。