我们来看一下 RBA 结构1.日志文件序列号(4字节)2.日志文件块编号(4字节)3.重做日志记录在日志块中的起始偏移字节数(2字节)REDO RECORD - Thread:1 RBA: 0x000069.00000006.0010 LEN: 0x0204 VLD: 0x05SCN: 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:0ktudh redo: slt: 0x0014 sqn: 0x000006e2 flg: 0x0412 siz: 136 fbi: 0uba: 0x00c00765.02bc.25 pxid: 0x0000.000.00000000CHANGE #2 TYP:0 CLS:20 AFN:3 DBA:0x00c00765 OBJ:4294967295 SCN:0x0000.00311b0d SEQ:2 OP:5.1 ENC:0 RBL:0ktudb redo: siz: 136 spc: 3182 flg: 0x0012 seq: 0x02bc rec: 0x25xid: 0x0002.014.000006e2ktubl redo: slt: 20 rci: 0 opc: 11.1 [objn: 5991 objd: 5991 tsn: 1]Undo type: Regular undo Begin trans Last buffer split: NoTemp Object: NoTablespace Undo: No0x00000000 prev ctl uba: 0x00c00765.02bc.23prev ctl max cmt scn: 0x0000.00311522 prev tx cmt scn: 0x0000.00311524txn start scn: 0xffff.ffffffff logon user: 0 prev brb: 12584799 prev bcl: 0 BuExt idx: 0 flg2: 0KDO undo record:KTB Redoop: 0x04 ver: 0x01compat bit: 4 (post-11) padding: 1op: L itl: xid: 0x0003.00c.000006f1 uba: 0x00c00205.025b.2fflg: C--- lkc: 0 scn: 0x0000.0030ea17KDO Op code: DRP row dependencies Disabledxtype: XA flags: 0x00000000 bdba: 0x0081370b hdba: 0x00800eb2itli: 1 ispac: 0 maxfr: 4858tabn: 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:0KTB Redoop: 0x01 ver: 0x01compat bit: 4 (post-11) padding: 1op: F xid: 0x0002.014.000006e2 uba: 0x00c00765.02bc.25KDO Op code: IRP row dependencies Disabledxtype: XA flags: 0x00000000 bdba: 0x0081370b hdba: 0x00800eb2itli: 1 ispac: 0 maxfr: 4858tabn: 0 slot: 10(0xa) size/delt: 71fb: --H-FL-- lb: 0x1 cc: 13null:01234567890123456789012345678901234567890123456789012345678901234567890123456789--------NNNN-col 0: [ 3] c2 28 25col 1: [13] 78 76 02 07 08 01 10 08 5d 6f 08 0c 3ccol 2: [ 2] c1 43col 3: [14] 52 4c 4d 24 45 56 54 43 4c 45 41 4e 55 50col 4: [ 6] 45 58 46 53 59 53col 5: [ 4] c3 02 1a 45col 6: [ 3] 52 55 4ecol 7: [ 9] 53 55 43 43 45 45 44 45 44col 8: *NULL*col 9: *NULL*col 10: *NULL*col 11: *NULL*col 12: [ 1] 801.1 To dump records based on RBA (Redo Block Address) --基于rdaalter 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 SCNalter 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:不常用,就不测试了
oracle redo log archive log,Oracle redo/archivelog dump
最新推荐文章于 2022-09-13 20:22:36 发布