redo/archivelog dump

我们来看一下  RBA 结构


1.日志文件序列号（4字节）
2.日志文件块编号（4字节）
3.重做日志记录在日志块中的起始偏移字节数（2字节）






 
REDO RECORD - Thread:1 RBA: 0x000069.00000006.0010 LEN: 0x0204 VLD: 0x05
SCN: 0x0000.00311c45 SUBSCN:  1 02/06/2018 23:00:15
(LWN RBA: 0x000069.00000006.0010 LEN: 0008 NST: 0001 SCN: 0x0000.00311c45)
CHANGE #1 TYP:0 CLS:19 AFN:3 DBA:0x00c00090 OBJ:4294967295 SCN:0x0000.00311b0e SEQ:1 OP:5.2 ENC:0 RBL:0
ktudh redo: slt: 0x0014 sqn: 0x000006e2 flg: 0x0412 siz: 136 fbi: 0
            uba: 0x00c00765.02bc.25    pxid:  0x0000.000.00000000
CHANGE #2 TYP:0 CLS:20 AFN:3 DBA:0x00c00765 OBJ:4294967295 SCN:0x0000.00311b0d SEQ:2 OP:5.1 ENC:0 RBL:0
ktudb redo: siz: 136 spc: 3182 flg: 0x0012 seq: 0x02bc rec: 0x25
            xid:  0x0002.014.000006e2  
ktubl redo: slt: 20 rci: 0 opc: 11.1 [objn: 5991 objd: 5991 tsn: 1]
Undo type:  Regular undo        Begin trans    Last buffer split:  No 
Temp Object:  No 
Tablespace Undo:  No 
             0x00000000  prev ctl uba: 0x00c00765.02bc.23 
prev ctl max cmt scn:  0x0000.00311522  prev tx cmt scn:  0x0000.00311524 
txn start scn:  0xffff.ffffffff  logon user: 0  prev brb: 12584799  prev bcl: 0 BuExt idx: 0 flg2: 0
KDO undo record:
KTB Redo 
op: 0x04  ver: 0x01  
compat bit: 4 (post-11) padding: 1
op: L  itl: xid:  0x0003.00c.000006f1 uba: 0x00c00205.025b.2f
                      flg: C---    lkc:  0     scn: 0x0000.0030ea17
KDO Op code: DRP row dependencies Disabled
  xtype: XA flags: 0x00000000  bdba: 0x0081370b  hdba: 0x00800eb2
itli: 1  ispac: 0  maxfr: 4858
tabn: 0 slot: 10(0xa)
CHANGE #3 TYP:2 CLS:1 AFN:2 DBA:0x0081370b OBJ:5991 SCN:0x0000.0030f80a SEQ:1 OP:11.2 ENC:0 RBL:0
KTB Redo 
op: 0x01  ver: 0x01  
compat bit: 4 (post-11) padding: 1
op: F  xid:  0x0002.014.000006e2    uba: 0x00c00765.02bc.25
KDO Op code: IRP row dependencies Disabled
  xtype: XA flags: 0x00000000  bdba: 0x0081370b  hdba: 0x00800eb2
itli: 1  ispac: 0  maxfr: 4858
tabn: 0 slot: 10(0xa) size/delt: 71
fb: --H-FL-- lb: 0x1  cc: 13
null:
01234567890123456789012345678901234567890123456789012345678901234567890123456789
--------NNNN-
col  0: [ 3]  c2 28 25
col  1: [13]  78 76 02 07 08 01 10 08 5d 6f 08 0c 3c
col  2: [ 2]  c1 43
col  3: [14]  52 4c 4d 24 45 56 54 43 4c 45 41 4e 55 50
col  4: [ 6]  45 58 46 53 59 53
col  5: [ 4]  c3 02 1a 45
col  6: [ 3]  52 55 4e
col  7: [ 9]  53 55 43 43 45 45 44 45 44
col  8: *NULL*
col  9: *NULL*
col 10: *NULL*
col 11: *NULL*
col 12: [ 1]  80
 



1.1 To dump records based on RBA (Redo Block Address) --基于rda


alter system dump logfile '/u01/app/oracle/oradata/aabbcc/redo03.log';


1.2 根据rba 区间范围来定位rda信息  (已知rda范围)

alter system dump logfile '/u01/app/oracle/oradata/aabbcc/redo03.log' rba min 105 5 rba max 105 7;

2.To dump records based in DBA (Data Block Address)


11g命令格式如下：
alter system dump logfile 'filename'  dba min fileno.blockno    dba max fileno.blockno; 


如果是Oracle 10g，需要省略'.'，即格式如下：
alter system dump logfile 'filename'  dba min fileno  blockno    dba max fileno  blockno;

 alter system dump logfile '/u01/app/oracle/oradata/aabbcc/redo03.log'  dba min 0  5  dba max 0 7; 


3.To dumprecords based on SCN


alter system dump logfile 'filename' scn min minscn scn max maxscn;

alter system dump logfile '/u01/app/oracle/oradata/aabbcc/redo03.log' scn min 3218500 scn max 3218502;


4.To dumprecords based on time.

--date to redodump time
由于需要脚本来进行转换,比较麻烦,我这里就不测试了


5.To dump records based on layer and opcode


不常用,就不测试了


6. Dump the file header information:


不常用,就不测试了

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7569309/viewspace-2150947/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7569309/viewspace-2150947/