redo logfile的内容

 

1)         使用 alter system dump logfile '/opt/oracle/oradata/orcl/redo02.log';转储logfile

 

2)         使用老盖给的@gettrcname取得转储文件名

 

SQL> @gettrcname

 

TRACE_FILE_NAME

--------------------------------------------------------------------------------

/opt/oracle/admin/orcl/udump/orcl_ora_14540.trc

3)         查找到emp表对应的OBJECT_ID

select object_id from user_objects where object_name='EMP';

 

 OBJECT_ID

----------

     51151

 

4)         根据 OBJECT_ID 找到对应的更改向量集

 

REDO RECORD - Thread:1 RBA: 0x00000d.00000157.0010 LEN: 0x0200 VLD: 0x0d

SCN: 0x0000.0015f428 SUBSCN:  1 05/25/2012 21:38:51

--更改向量的1 记录对于col 5 的修改（修改前的值为 3000）AFN:4 绝对文件号为4，本机中的文件为user表空间的数据文件users_01.dbf

CHANGE #1 TYP:2 CLS: 1 AFN:4 DBA:0x01000020 OBJ:51151 SCN:0x0000.0007f48c SE

Q: 16 OP:11.5

KTB Redo

op: 0x11  ver: 0x01 

op: F  xid:  0x0009.01f.000002a8    uba: 0x008002e6.0152.21

Block cleanout record, scn:  0x0000.0015f422 ver: 0x01 opt: 0x02, entries fo

llow...

  itli: 1  flg: 2  scn: 0x0000.0007f48c

KDO Op code: URP row dependencies Disabled

  xtype: XAxtype KDO_KDOM2 flags: 0x00000080  bdba: 0x01000020  hdba: 0x0100

001b

itli: 2  ispac: 0  maxfr: 4858

tabn: 0 slot: 7(0x7) flag: 0x2c lock: 2 ckix: 0

ncol: 8 nnew: 1 size: 0

Vector content:

col  5: [ 2]  c2 29

--更改向量2 记录对回滚段头的修改，分配事务表。

CHANGE #2 TYP:0 CLS:33 AFN:2 DBA:0x00800089 OBJ:4294967295 SCN:0x0000.0015f4

0e SEQ:  2 OP:5.2

ktudh redo: slt: 0x001f sqn: 0x000002a8 flg: 0x0012 siz: 128 fbi: 0

            uba: 0x008002e6.0152.21    pxid:  0x0000.000.00000000

--更改向量3

CHANGE #3 TYP:0 CLS:33 AFN:2 DBA:0x00800089 OBJ:4294967295 SCN:0x0000.0015f4

28 SEQ:  1 OP:5.4

ktucm redo: slt: 0x001f sqn: 0x000002a8 srt: 0 sta: 9 flg: 0x2

ktucf redo: uba: 0x008002e6.0152.21 ext: 2 spc: 3856 fbi: 0

--更改向量4 记录对于col 5 的修改（修改前的值为 3000）AFN:2 绝对文件号为2，本机中的文件为undo表空间的数据文件undotbs_01.dbf

CHANGE #4 TYP:0 CLS:34 AFN:2 DBA:0x008002e6 OBJ:4294967295 SCN:0x0000.0015f4

0e SEQ:  2 OP:5.1

ktudb redo: siz: 128 spc: 3986 flg: 0x0012 seq: 0x0152 rec: 0x21

            xid:  0x0009.01f.000002a8 

ktubl redo: slt: 31 rci: 0 opc: 11.1 objn: 51151 objd: 51151 tsn: 4

Undo type:  Regular undo        Begin trans    Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

             0x00000000  prev ctl uba: 0x008002e6.0152.1f

prev ctl max cmt scn:  0x0000.0015ee0a  prev tx cmt scn:  0x0000.0015ee36

txn start scn:  0x0000.00000000  logon user: 54  prev brb: 8389342  prev bcl

: 0 KDO undo record:

KTB Redo

op: 0x03  ver: 0x01 

op: Z

KDO Op code: URP row dependencies Disabled

  xtype: XAxtype KDO_KDOM2 flags: 0x00000080  bdba: 0x01000020  hdba: 0x0100

001b

itli: 2  ispac: 0  maxfr: 4858

tabn: 0 slot: 7(0x7) flag: 0x2c lock: 0 ckix: 0

ncol: 8 nnew: 1 size: 0

Vector content:

col  5: [ 2]  c2 1f

 

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

转载于:http://blog.itpub.net/26948115/viewspace-731001/