使用Logdump进行Trail分析

1、logdump数据记录格式化

open /u02/ogg/ggs/dirdat/ab******

pos ***

ghdr on

detail on

detail data

usertoken on

 

2、查看单个trail文件的数据记录

 

count

count detail

count start *** end ***

eg: COUNT DETAIL START 2016-11-01 12:00:00 , END 2017-01-12 12:00:00

 

3、进行单表过滤

FILTER INCLUDE/EXCLUDE FILENAME ***.***

FILTER SHOW

FILTER CLEAR

eg: FILTER INCLUDE FILENAME SCOTT.TIGER

 

4、查看Transaction信息

#查看当前事务的最后一个rba号

scanforendtrans

#查找下一个事务的起始rba号

scanforheader

 

5、查看当前操作的类型（可以通过IOTYPE查看，也可以查看具体的显示）

Logdump 84 >n
___________________________________________________________________ 
Hdr-Ind    :     E  (x45)     Partition  :     .  (x04)  
UndoFlag   :     .  (x00)     BeforeAfter:     A  (x41)  
RecLength  :   842  (x034a)   IO Time    : 2018/01/02 08:59:42.001.657   
IOType     :     5  (x05)     OrigNode   :   255  (xff) 
TransInd   :     .  (x03)     FormatType :     R  (x52) 
SyskeyLen  :     0  (x00)     Incomplete :     .  (x00) 
AuditRBA   :     198407       AuditPos   : 253669624 
Continued  :     N  (x00)     RecCount   :     1  (x01) 

2018/01/02 08:59:42.001.657 Insert               Len   842 RBA 2425 
Name: SCOTT.TIGER
After  Image:                                             Partition 4   G  s   
 0000 000e 0000 000a 3232 3230 3736 3532 3630 0001 | ........2220765260..  
 001f ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 | ....1900-01-01:00:00  
 3a30 302e 3030 3030 3030 3030 3000 0200 1600 0000 | :00.000000000.......  
 12e5 8d95 e7ac 94e8 b584 e987 91e5 bd92 e99b 8600 | ....................  
 0300 0a00 0000 0000 0000 0000 0000 0400 2e00 0000 | ....................  
 2a7b 2249 4322 3a31 3031 2c22 4f49 223a 3935 3630 | *{"IC":101,"OI":9560  
 3638 2c22 5054 223a 3230 3138 3031 3032 3038 3539 | 68,"PT":201801020859  
Column     0 (x0000), Len    14 (x000e)  
 0000 000a 3232 3230 3736 3532 3630                | ....2220765260  
Column     1 (x0001), Len    31 (x001f)  
 ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0  
 302e 3030 3030 3030 3030 30                       | 0.000000000

... ...

Logdump 85 >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 86 >

 6、跳过当前的rba

alter replicat R_*** ,extseqno ***, extrba ***