ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle dump undo 说明

Oracle dump undo 说明

原创 Linux操作系统 作者:vcdog 时间:2011-08-27 05:31:07 0 删除 编辑

 

一. undo 的一些准备知识

在之前的blog里有对undo segment 有说明:

       Current online Redo 和 Undo 损坏的处理方法

       http://blog.csdn.net/tianlesoftware/article/details/6261475

 

1.1 当undo_management被设置成MENUAL时使用系统回滚段, 即将undo records 记录到SYSTEM 表空间下的SYSTEM段。

 

SQL> col segment_name format a10

SQL> select segment_name,tablespace_name,bytes,next_extent  from dba_segments where segment_type='ROLLBACK';

 

SEGMENT_NATABLESPACE_NAME       BYTES NEXT_EXTENT

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

SYSTEM     SYSTEM                 393216     1048576

 

       通过上面的这条语句,我们查到了这个用于rollback 的system segment 存在与system 表空间。 默认情况下,只有一个segment,并且它还比较小,所以,如果使用system 段来存储undo records。肯定会影响数据库的性能。 所以Oracle 是建议使用Undo tablespace 来管理undo records。

 

1.2 当undo_management设置成AUTO时使用UNDOtablespace来管理回滚段。 这个时候,我们将有多个undo segment,并且这些segment 是存放在UNDO 表空间里的。 这样对DB的性能就会提高。

 

SYS@anqing2(rac2)> select segment_name,tablespace_name, header_file, header_block,bytes  from dba_segments where segment_type='TYPE2 UNDO';

 

SEGMENT_NAME    TABLESPACE_NAME HEADER_FILEHEADER_BLOCK      BYTES

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

_SYSSMU1$       UNDOTBS1                  2            9 107806720

_SYSSMU2$       UNDOTBS1                  2           25 111411200

_SYSSMU3$       UNDOTBS1                  2           41 120586240

_SYSSMU4$       UNDOTBS1                  2           57 100990976

_SYSSMU5$       UNDOTBS1                  2           73 112721920

_SYSSMU6$       UNDOTBS1                  2           89 117243904

_SYSSMU7$       UNDOTBS1                  2          105 106233856

_SYSSMU8$       UNDOTBS1                  2          121 155975680

_SYSSMU9$       UNDOTBS1                  2          137 184287232

_SYSSMU10$      UNDOTBS1                  2          153 149356544

_SYSSMU11$      UNDOTBS2                  5            9     131072

 

SEGMENT_NAME    TABLESPACE_NAME HEADER_FILEHEADER_BLOCK      BYTES

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

_SYSSMU12$      UNDOTBS2                  5           25     131072

_SYSSMU13$      UNDOTBS2                  5           41     131072

_SYSSMU14$      UNDOTBS2                  5           57     131072

_SYSSMU15$      UNDOTBS2                  5           73     131072

_SYSSMU16$      UNDOTBS2                  5           89     131072

_SYSSMU17$      UNDOTBS2                  5          105     131072

_SYSSMU18$      UNDOTBS2                  5          121    131072

_SYSSMU19$      UNDOTBS2                  5          137     131072

_SYSSMU20$      UNDOTBS2                  5          153     131072

 

20 rows selected.

 

       通过以上SQL的查询结果,我们可以看出,每个节点有10个undo segment来存放undo records。

 

       以上我们是通过dba_segment 表查看的结果。 也可以通过v$rollstat和v$rollname 两个视图来查看信息。 这2个视图会显示所有rollback 段的信息。 包括system段和undo段。

 

SQL> col name format a15

SQL> select s.usn,n.name,s.extents,s.hwmsize,s.status from v$rollstat s, v$rollname n wheres.usn=n.usn;

 

       USNNAME               EXTENTS    HWMSIZESTATUS

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

         0SYSTEM                   6     385024ONLINE

         1_SYSSMU1$                3    7659520ONLINE

         2_SYSSMU2$                3    9691136ONLINE

         3_SYSSMU3$                4    7462912ONLINE

         4_SYSSMU4$                3   76668928ONLINE

         5_SYSSMU5$                4    8511488ONLINE

         6_SYSSMU6$                3    7462912ONLINE

         7_SYSSMU7$                3   33480704ONLINE

         8_SYSSMU8$                3    8577024ONLINE

         9_SYSSMU9$                3    7462912ONLINE

        10_SYSSMU10$               3   13754368ONLINE

 

11 rows selected.

 

1.3 查看事务当前使用的undo segment

       可以通过v$transaction 视图来确认事务当前使用的undo segment信息。 确定undo segment之后,就可以进行相关的dump 操作。 关于v$transaction 视图的说明,参考官方文档:

       http://download.oracle.com/docs/cd/E11882_01/server.112/e17110/dynviews_3114.htm#REFRN30291

 

部分说明如下:

ADDR

RAW(4 | 8)

Address of the transaction state object

XIDUSN

NUMBER

Undo segment number

XIDSLOT

NUMBER

Slot number

XIDSQN

NUMBER

Sequence number

UBAFIL

NUMBER

Undo block address (UBA) filenum

UBABLK

NUMBER

UBA block number

UBASQN

NUMBER

UBA sequence number

UBAREC

NUMBER

UBA record number

STATUS

VARCHAR2(16)

Status

 

--查看当前的SID信息

SYS@anqing2(rac2)> select sid fromv$mystat where rownum=1;

SID

----------

147

SYS@anqing2(rac2)> update ta set name='dave'where name='ora_rowscn';

474 rows updated.

 

--查看v$transaction中正在使用的回滚段号

SYS@anqing2(rac2)> selectxidusn,xidslot,xidsqn,ubablk,ubafil,ubarec from v$transaction;

   XIDUSN    XIDSLOT     XIDSQN    UBABLK     UBAFIL     UBAREC

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

       11         23       1010         12          5          9

--xidusn:undo segment number

--xidslot:slot number

--xidsqn:sequence number

--ubafil:undo block address (uba) filenum

--ubablk:uba block number

--ubarec:UBA record number

 

       其中UBA的格式为:DBA.seq#.rec#,关于UBA的这部分内容, 在我有关itl 的那篇blog里有说明:

       Orace ITL(InterestedTransaction List) 说明

       http://blog.csdn.net/tianlesoftware/article/details/6573988

 

--通过xidusn号和v$rollname确定正在使用的undo segment name

SYS@anqing2(rac2)> select usn,name from v$rollname where usn=11;

       USN NAME

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

        11 _SYSSMU11$

 

--commit之后,对应的事务信息就没有了。

SYS@anqing2(rac2)> commit;

Commit complete.

SYS@anqing2(rac2)> selectxidusn,xidslot,xidsqn,ubablk,ubafil,ubarec from v$transaction;

no rows selected

SYS@anqing2(rac2)>

 

 

二. Dump Undo 信息

2.1 dump undo header

在1.3节里已经做了一些测试,这里直接使用上面测试的结果。

 

SYS@anqing2(rac2)> alter system dump undo header '_SYSSMU11$';

System altered.

 

SYS@anqing2(rac2)> oradebug setmypid

Statement processed.

SYS@anqing2(rac2)> oradebug tracefile_name

/u01/app/oracle/admin/anqing/udump/anqing2_ora_3078.trc

 

[oracle@rac2 ~]$ cat /u01/app/oracle/admin/anqing/udump/anqing2_ora_3078.trc

/u01/app/oracle/admin/anqing/udump/anqing2_ora_3078.trc

Oracle Database 10g Enterprise EditionRelease 10.2.0.4.0 - Production

With the Partitioning, Real ApplicationClusters, OLAP, Data Mining

and Real Application Testing options

ORACLE_HOME =/u01/app/oracle/product/10.2.0/db_1

System name:    Linux

Node name:      rac2

Release:        2.6.18-194.el5

Version:        #1 SMP Tue Mar 16 21:52:43 EDT 2010

Machine:        i686

Instance name: anqing2

Redo thread mounted by this instance: 2

Oracle process number: 32

Unix process pid: 3078, image: oracle@rac2(TNS V1-V3)

 

*** 2011-08-09 13:56:10.376

*** ACTION NAME:() 2011-08-09 13:56:10.375

*** MODULE NAME:(sqlplus@rac2 (TNS V1-V3))2011-08-09 13:56:10.375

*** SERVICE NAME:(SYS$USERS) 2011-08-0913:56:10.375

*** SESSION ID:(135.38749) 2011-08-0913:56:10.375

 

********************************************************************************

Undo Segment:  _SYSSMU11$ (11)

********************************************************************************

 Extent Control Header

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

 Extent Header:: spare1: 0     spare2: 0      #extents: 2      #blocks: 15   

                  last map  0x00000000 #maps: 0      offset: 4080 

      Highwater:: 0x0140000d  ext#: 0      blk#: 3      ext size: 7    

 #blocks in seg. hdr's freelists: 0    

 #blocks below: 0    

 mapblk  0x00000000  offset: 0    

                   Unlocked

    Map Header:: next  0x00000000  #extents: 2   obj#: 0      flag: 0x40000000

 Extent Map

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

  0x0140000a  length: 7    

  0x01400041  length: 8    

 

 Retention Table

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

 Extent Number:0  Commit Time: 1312867343

 Extent Number:1  Commit Time: 1312867343

 

  TRNCTL:: seq: 0x00c9 chd: 0x0016 ctl: 0x0024 inc: 0x00000000 nfb: 0x0002

           mgc: 0x8201 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)

           uba: 0x0140000d.00c9.04 scn: 0x0000.0070e385

Version: 0x01

 FREE BLOCK POOL::

   uba: 0x0140000d.00c9.04 ext: 0x0 spc: 0x1c42 

   uba: 0x0140000c.00c9.09 ext: 0x0 spc: 0x1bc0 

   uba: 0x00000000.00c0.1f ext: 0x1 spc: 0xd4c  

   uba: 0x00000000.0000.00 ext: 0x0 spc: 0x0    

   uba: 0x00000000.0000.00 ext: 0x0 spc: 0x0    

  TRNTBL::

 

 index  state cflags  wrap#   uel         scn            dba            parent-xid    nub    stmt_num    cmt

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

  0x00    9    0x00 0x03f3  0x0001  0x0000.0070ec74  0x0140000f 0x0000.000.00000000 0x00000001   0x00000000  1312670852

  0x01    9    0x00 0x03f2  0x0004  0x0000.0070ecec  0x0140000f 0x0000.000.00000000 0x00000001   0x00000000  1312671061

  0x02    9    0x00 0x03f3  0x0012  0x0000.0071f2ca  0x01400010 0x0000.000.00000000 0x00000001   0x00000000  1312793154

  0x03    9    0x00 0x03ee  0x0023  0x0000.00729e4b  0x01400041 0x0000.000.00000000 0x00000001   0x00000000  1312865754

.....

 

2.2 Dump 整个blcok

       通过v$transaction 视图可以确定uba 对应的fileno 和blockno。 如:

 

SYS@anqing2(rac2)> selectxidusn,xidslot,xidsqn,ubablk,ubafil,ubarec from v$transaction;

   XIDUSN    XIDSLOT     XIDSQN    UBABLK     UBAFIL     UBAREC

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

       11         23       1010         12          5          9

 

直接根据结果dump 对应的block 就ok了。

 

SYS@anqing2(rac2)> alter system dump datafile 5 block 12;

System altered.

 

SYS@anqing2(rac2)> oradebug tracefile_name

/u01/app/oracle/admin/anqing/udump/anqing2_ora_3078.trc

 

Trace file 内容:

Start dump data blocks tsn: 5 file#: 5minblk 12 maxblk 12

buffer tsn: 5 rdba: 0x0140000c (5/12)

scn: 0x0000.0072a1e9 seq: 0x09 flg: 0x04tail: 0xa1e90209

frmt: 0x02 chkval: 0xd566 type: 0x02=KTUUNDO BLOCK

Hex dump of block: st=0, typ_found=1

Dump of memory from 0x0D741400 to0x0D743400

D741400 0000A202 0140000C 0072A1E904090000  [......@...r.....]

D741410 0000D566 0017000B 000003F2090900C9  [f...............]

......

D7433F0 00000000 0041175A 000001DBA1E90209  [....Z.A.........]

 

********************************************************************************

UNDO BLK: 

xid: 0x000b.017.000003f2  seq: 0xc9 cnt: 0x9   irb: 0x9   icl: 0x0  flg: 0x0000

 

 RecOffset      Rec Offset      Rec Offset      Rec Offset      Rec Offset

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

0x01 0x1f64     0x02 0x1f08     0x03 0x1e84     0x04 0x1e28     0x05 0x1da4    

0x06 0x1d48     0x07 0x1cc4     0x08 0x1c68     0x09 0x1be4    

 

*-----------------------------

* Rec #0x1  slt: 0x17 objn: 53519(0x0000d10f)  objd:54764  tblspc: 0(0x00000000)

*      Layer:  11(Row)   opc: 1   rci 0x00  

Undo type: Regular undo   Last buffersplit:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x0140000b

*-----------------------------

KDO undo record:

KTB Redo

op: 0x02 ver: 0x01 

op: C uba: 0x0140000b.00c9.46

KDO Op code: URP row dependencies Disabled

 xtype: XA flags: 0x00000000  bdba:0x018028f1  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 43(0x2b) flag: 0x0c lock: 0ckix: 12

ncol: 2 nnew: 1 size: 6

col 1: [10]  6f 72 61 5f 72 6f 77 7363 6e

 

*-----------------------------

* Rec #0x2  slt: 0x17 objn: 53519(0x0000d10f)  objd:54764  tblspc: 0(0x00000000)

*      Layer:  11 (Row)   opc: 1  rci 0x01  

Undo type: Regular undo   Last buffersplit:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x02 ver: 0x01 

op: C uba: 0x0140000b.00c9.47

KDO Op code: LKR row dependencies Disabled

 xtype: XA flags: 0x00000000  bdba:0x0041175a  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 477 to: 0

 

*-----------------------------

* Rec #0x3  slt: 0x17 objn: 53519(0x0000d10f)  objd:54764  tblspc: 0(0x00000000)

*      Layer:  11 (Row)   opc: 1  rci 0x02  

Undo type: Regular undo   Last buffersplit:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x02 ver: 0x01 

op: C uba: 0x0140000c.00c9.01

KDO Op code: URP row dependencies Disabled

 xtype: XA flags: 0x00000000  bdba:0x018028f1  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 44(0x2c) flag: 0x0c lock: 0ckix: 12

ncol: 2 nnew: 1 size: 6

col 1: [10]  6f 72 61 5f 72 6f 77 7363 6e

 

*-----------------------------

......

*-----------------------------

* Rec #0x9  slt: 0x17 objn: 53519(0x0000d10f)  objd:54764  tblspc: 0(0x00000000)

*      Layer:  11 (Row)   opc: 1  rci 0x08  

Undo type: Regular undo   Last buffersplit:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x02 ver: 0x01 

op: C uba: 0x0140000c.00c9.07

KDO Op code: URP row dependencies Disabled

 xtype: XA flags: 0x00000000  bdba:0x018028f1  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 47(0x2f) flag: 0x0c lock: 0ckix: 12

ncol: 2 nnew: 1 size: 6

col 1: [10]  6f 72 61 5f 72 6f 77 7363 6e

 

End dump data blocks tsn: 5 file#: 5 minblk12 maxblk 12

[oracle@rac2 ~]$

 

 

2.3 根据事务进行Dump

       事务的信息还是通过v$transaction 进行查看:

SYS@anqing2(rac2)> selectxidusn,xidslot,xidsqn,ubablk,ubafil,ubarec from v$transaction;

   XIDUSN    XIDSLOT     XIDSQN    UBABLK     UBAFIL     UBAREC

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

       11         23       1010         12          5          9

 

SYS@anqing2(rac2)> select usn,name fromv$rollname where usn=11;

      USN NAME

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

       11 _SYSSMU11$

 

Dump命令格式如下:

SQL>ALTER SYSTEM DUMP UNDO BLOCK'segment_name' XID xidusn xidslot xidsqn;

 

SYS@anqing2(rac2)> ALTER SYSTEM DUMP UNDO BLOCK '_SYSSMU11$' XID 11 23 1010;

System altered.

 

SYS@anqing2(rac2)> oradebug tracefile_name

/u01/app/oracle/admin/anqing/udump/anqing2_ora_3078.trc

 

[oracle@rac2 ~]$ head -500/u01/app/oracle/admin/anqing/udump/anqing2_ora_3078.trc 

*** 2011-08-09 14:12:56.163

 

********************************************************************************

Undo Segment:  _SYSSMU11$ (11)

xid: 0x000b.017.000003f2

Low Blk  :   (0, 0)

High Blk :   (1, 7)

Object Id :   ALL

Layer    :   ALL

Opcode   :   ALL

Level    :   2

 

********************************************************************************

UNDO BLK: Extent: 0   Block: 2   dba (file#, block#): 5,0x0000000c

xid: 0x000b.017.000003f2  seq: 0xc9 cnt: 0x9   irb: 0x9   icl: 0x0  flg: 0x0000

 

 RecOffset      Rec Offset      Rec Offset      Rec Offset      Rec Offset

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

0x01 0x1f64     0x02 0x1f08     0x03 0x1e84     0x04 0x1e28     0x05 0x1da4    

0x06 0x1d48     0x07 0x1cc4     0x08 0x1c68     0x09 0x1be4    

 

*-----------------------------

* Rec #0x9 slt: 0x17  objn:53519(0x0000d10f)  objd: 54764  tblspc: 0(0x00000000)

*      Layer:  11 (Row)   opc: 1  rci 0x08  

Undo type: Regular undo   Last buffersplit:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x02 ver: 0x01 

op: C uba: 0x0140000c.00c9.07

KDO Op code: URP row dependencies Disabled

 xtype: XA flags: 0x00000000  bdba:0x018028f1  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 47(0x2f) flag: 0x0c lock: 0ckix: 12

ncol: 2 nnew: 1 size: 6

col 1: [10]  6f 72 61 5f 72 6f 77 7363 6e

 

*-----------------------------

* Rec #0x8 slt: 0x17  objn:53519(0x0000d10f)  objd: 54764  tblspc: 0(0x00000000)

*      Layer:  11 (Row)   opc: 1  rci 0x07  

Undo type: Regular undo   Last buffersplit:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x02 ver: 0x01 

op: C uba: 0x0140000c.00c9.06

KDO Op code: LKR row dependencies Disabled

 xtype: XA flags: 0x00000000  bdba:0x0041175a  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 482 to: 0

 

*-----------------------------

* Rec #0x7 slt: 0x17  objn:53519(0x0000d10f)  objd: 54764  tblspc: 0(0x00000000)

*      Layer:  11 (Row)   opc: 1  rci 0x06  

Undo type: Regular undo   Last buffersplit:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x02 ver: 0x01 

op: C uba: 0x0140000c.00c9.05

KDO Op code: URP row dependencies Disabled

 xtype: XA flags: 0x00000000  bdba:0x018028f1  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 46(0x2e) flag: 0x0c lock: 0ckix: 12

ncol: 2 nnew: 1 size: 6

col 1: [10]  6f 72 61 5f 72 6f 77 7363 6e

 

*-----------------------------

* Rec #0x6 slt: 0x17  objn:53519(0x0000d10f)  objd: 54764  tblspc: 0(0x00000000)

*      Layer:  11 (Row)   opc: 1  rci 0x05  

Undo type: Regular undo   Last buffersplit:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x02 ver: 0x01 

op: C uba: 0x0140000c.00c9.04

KDO Op code: LKR row dependencies Disabled

 xtype: XA flags: 0x00000000  bdba:0x0041175a  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 480 to: 0

 

*-----------------------------

* Rec #0x5 slt: 0x17  objn:53519(0x0000d10f)  objd: 54764  tblspc: 0(0x00000000)

*      Layer:  11 (Row)   opc: 1  rci 0x04  

Undo type: Regular undo   Last buffersplit:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x02 ver: 0x01 

op: C uba: 0x0140000c.00c9.03

KDO Op code: URP row dependencies Disabled

 xtype: XA flags: 0x00000000  bdba:0x018028f1  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 45(0x2d) flag: 0x0c lock: 0ckix: 12

ncol: 2 nnew: 1 size: 6

col 1: [10]  6f 72 61 5f 72 6f 77 7363 6e

 

*-----------------------------

* Rec #0x4 slt: 0x17  objn:53519(0x0000d10f)  objd: 54764  tblspc: 0(0x00000000)

*      Layer:  11 (Row)   opc: 1  rci 0x03  

Undo type: Regular undo   Last buffersplit:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x02 ver: 0x01 

op: C uba: 0x0140000c.00c9.02

KDO Op code: LKR row dependencies Disabled

 xtype: XA flags: 0x00000000  bdba:0x0041175a  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 479 to: 0

 

*-----------------------------

* Rec #0x3 slt: 0x17  objn: 53519(0x0000d10f)  objd: 54764 tblspc: 0(0x00000000)

*      Layer:  11 (Row)   opc: 1  rci 0x02  

Undo type: Regular undo   Last buffersplit:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x02 ver: 0x01 

op: C uba: 0x0140000c.00c9.01

KDO Op code: URP row dependencies Disabled

 xtype: XA flags: 0x00000000  bdba:0x018028f1  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 44(0x2c) flag: 0x0c lock: 0ckix: 12

ncol: 2 nnew: 1 size: 6

col 1: [10]  6f 72 61 5f 72 6f 77 7363 6e

 

*-----------------------------

* Rec #0x2 slt: 0x17  objn:53519(0x0000d10f)  objd: 54764  tblspc: 0(0x00000000)

*      Layer:  11 (Row)   opc: 1  rci 0x01  

Undo type: Regular undo   Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x02 ver: 0x01 

op: C uba: 0x0140000b.00c9.47

KDO Op code: LKR row dependencies Disabled

 xtype: XA flags: 0x00000000  bdba:0x0041175a  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 477 to: 0

 

*-----------------------------

* Rec #0x1 slt: 0x17  objn:53519(0x0000d10f)  objd: 54764  tblspc: 0(0x00000000)

*      Layer:  11 (Row)   opc: 1  rci 0x00  

Undo type: Regular undo   Last buffersplit:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x0140000b

*-----------------------------

KDO undo record:

KTB Redo

op: 0x02 ver: 0x01 

op: C uba: 0x0140000b.00c9.46

KDO Op code: URP row dependencies Disabled

 xtype: XA flags: 0x00000000  bdba:0x018028f1  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 43(0x2b) flag: 0x0c lock: 0ckix: 12

ncol: 2 nnew: 1 size: 6

col 1: [10]  6f 72 61 5f 72 6f 77 7363 6e

 

 

********************************************************************************

UNDO BLK: Extent: 0   Block: 1   dba (file#, block#): 5,0x0000000b

xid: 0x000b.017.000003f2  seq: 0xc9 cnt: 0x47  irb: 0x47  icl: 0x0  flg: 0x0000

 

 Rec Offset      Rec Offset      Rec Offset      Rec Offset      Rec Offset

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

0x01 0x1f8c     0x02 0x1f08     0x03 0x1eac     0x04 0x1e28     0x05 0x1dcc    

0x06 0x1d48     0x07 0x1cec     0x08 0x1c68     0x09 0x1c0c     0x0a 0x1b88    

0x0b 0x1b2c     0x0c 0x1aa8     0x0d 0x1a4c     0x0e 0x19c8     0x0f 0x196c    

0x10 0x18e8     0x11 0x188c     0x12 0x1808     0x13 0x17ac     0x14 0x1728    

0x15 0x16cc    0x16 0x1648     0x17 0x15ec     0x18 0x1568     0x19 0x150c    

0x1a 0x1488     0x1b 0x142c     0x1c 0x13a8     0x1d 0x134c     0x1e 0x12c8    

0x1f 0x126c     0x20 0x11e8     0x21 0x118c     0x22 0x1108     0x23 0x10ac    

0x24 0x1028     0x25 0x0fcc     0x26 0x0f48     0x27 0x0eec     0x28 0x0e68    

0x29 0x0e0c     0x2a 0x0d88     0x2b 0x0d2c     0x2c 0x0ca8     0x2d 0x0c4c    

0x2e 0x0bc8     0x2f 0x0b6c     0x30 0x0ae8     0x31 0x0a8c     0x32 0x0a08    

0x33 0x09ac     0x34 0x0928     0x35 0x08cc     0x36 0x0848     0x37 0x07ec    

0x38 0x0768     0x39 0x070c     0x3a 0x0688     0x3b 0x062c     0x3c 0x05a8    

0x3d 0x054c     0x3e 0x04c8     0x3f 0x046c     0x40 0x03e8     0x41 0x038c    

0x42 0x0308     0x43 0x02ac     0x44 0x0228     0x45 0x01cc     0x46 0x0148    

0x47 0x00ec    

 

*-----------------------------

* Rec #0x47 slt: 0x17  objn:53519(0x0000d10f)  objd: 54764  tblspc: 0(0x00000000)

*      Layer:  11 (Row)   opc: 1  rci 0x46  

Undo type: Regular undo   Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x02 ver: 0x01 

op: C uba: 0x0140000b.00c9.45

KDO Op code: LKR row dependencies Disabled

 xtype: XA flags: 0x00000000  bdba:0x0041175a  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 475 to: 0

 

*-----------------------------

* Rec #0x46 slt: 0x17  objn:53519(0x0000d10f)  objd: 54764  tblspc: 0(0x00000000)

*      Layer:  11 (Row)   opc: 1  rci 0x45  

Undo type: Regular undo   Last buffersplit:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x02 ver: 0x01 

op: C uba: 0x0140000b.00c9.44

KDO Op code: URP row dependencies Disabled

 xtype: XA flags: 0x00000000  bdba:0x018028f1  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 42(0x2a) flag: 0x0c lock: 0ckix: 12

ncol: 2 nnew: 1 size: 6

col 1: [10]  6f 72 61 5f 72 6f 77 7363 6e

 

 

[oracle@rac2 ~]$ tail-100 /u01/app/oracle/admin/anqing/udump/anqing2_ora_3078.trc 

 xtype: XA flags: 0x00000000  bdba:0x0041175a  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 13(0xd) flag: 0x2c lock: 0ckix: 12

ncol: 2 nnew: 1 size: 6

col 1: [10]  6f 72 61 5f 72 6f 77 7363 6e

 

*-----------------------------

* Rec #0x10 slt: 0x17  objn: 53519(0x0000d10f)  objd: 54764 tblspc: 0(0x00000000)

*      Layer:  11 (Row)   opc: 1  rci 0x0f  

Undo type: Regular undo   Last buffersplit:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x02 ver: 0x01 

op: C uba: 0x01400041.00c8.0f

KDO Op code: URP row dependencies Disabled

 xtype: XA flags: 0x00000000  bdba:0x0041175a  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 12(0xc) flag: 0x2c lock: 0ckix: 12

ncol: 2 nnew: 1 size: 6

col 1: [10]  6f 72 61 5f 72 6f 77 7363 6e

 

*-----------------------------

* Rec #0xf slt: 0x17  objn:53519(0x0000d10f)  objd: 54764  tblspc: 0(0x00000000)

*      Layer:  11 (Row)   opc: 1  rci 0x0e  

Undo type: Regular undo   Last buffersplit:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x02 ver: 0x01 

op: C uba: 0x01400041.00c8.0e

KDO Op code: URP row dependencies Disabled

 xtype: XA flags: 0x00000000  bdba:0x0041175a  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 11(0xb) flag: 0x2c lock: 0ckix: 12

ncol: 2 nnew: 1 size: 6

col 1: [10]  6f 72 61 5f 72 6f 77 7363 6e

 

*-----------------------------

* Rec #0xe slt: 0x17  objn:53519(0x0000d10f)  objd: 54764  tblspc: 0(0x00000000)

*      Layer:  11 (Row)   opc: 1  rci 0x0d  

Undo type: Regular undo   Last buffersplit:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x02 ver: 0x01 

op: C uba: 0x01400041.00c8.0d

KDO Op code: URP row dependencies Disabled

 xtype: XA flags: 0x00000000  bdba:0x0041175a  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 10(0xa) flag: 0x2c lock: 0ckix: 12

ncol: 2 nnew: 1 size: 6

col 1: [10]  6f 72 61 5f 72 6f 77 7363 6e

 

*-----------------------------

* Rec #0xd slt: 0x17  objn:53519(0x0000d10f)  objd: 54764  tblspc: 0(0x00000000)

*      Layer:  11 (Row)   opc: 1  rci 0x00  

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

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

uba: 0x01400041.00c8.0c ctl max scn:0x0000.0070e148 prv tx scn: 0x0000.0070e216

txn start scn: scn: 0x0000.0072a1db logonuser: 0

 prevbrb: 20971534 prev bcl: 0

KDO undo record:

KTB Redo

op: 0x04 ver: 0x01 

op: L itl: xid:  0x0013.007.00000340uba: 0x014015bc.00a2.11

                      flg: C---    lkc: 0     scn: 0x0000.005bf84e

KDO Op code: URP row dependencies Disabled

 xtype: XA flags: 0x00000000  bdba:0x0041175a  hdba: 0x00411759

itli: 2 ispac: 0  maxfr: 4863

tabn: 0 slot: 9(0x9) flag: 0x2c lock: 0ckix: 12

ncol: 2 nnew: 1 size: 6

col 1: [10]  6f 72 61 5f 72 6f 77 7363 6e

 

 

+++++++++++ Next block not in extent map -rollback segment has been shrunk.

+ WARNING + Block dba (file#, block#):0,0x00000000

+++++++++++

 

 

*************************************

Total undo blocks scanned  = 11

Total undo records scanned = 667

Total undo blocks dumped   = 11

Total undo records dumped  = 667

 

##Total warnings issued = 1

*************************************

 

 

 

 

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

Blog: http://blog.csdn.net/tianlesoftware

Weibo: http://weibo.com/tianlesoftware

Email: dvd.dba@gmail.com

DBA1 群:62697716(满);   DBA2 群:62697977(满)  DBA3 群:62697850(满)  

DBA 超级群:63306533(满);  DBA4 群: 83829929(满) DBA5群: 142216823(满) 

DBA6 群:158654907(满)  聊天 群:40132017(满)   聊天2群:69087192(满)

--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请

作者:tianlesoftware 发表于2011-8-9 14:26:36 原文链接
阅读:315 评论:0 查看评论


Link URL: http://blog.csdn.net/tianlesoftware/article/details/6672417

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

请登录后发表评论 登录
全部评论

注册时间:2011-08-21

  • 博文量
    28
  • 访问量
    33147