Oracle dump undo 说明

最新推荐文章于 2024-04-20 18:58:30 发布

Dave

最新推荐文章于 2024-04-20 18:58:30 发布

阅读量7.4k

点赞数 1

分类专栏： Oracle Advanced Knowledge 文章标签： oracle dependencies object layer system

本文链接：https://blog.csdn.net/tianlesoftware/article/details/6672417

版权

Oracle Advanced Knowledge 专栏收录该内容

187 篇文章 8 订阅

订阅专栏

一. undo 的一些准备知识

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

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

http://www.cndba.cn/Dave/article/525

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://www.cndba.cn/Dave/article/1397

--通过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

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

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

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

QQ:492913789

Email:ahdba@qq.com

Blog: http://www.cndba.cn/dave

Weibo: http://weibo.com/tianlesoftware

Twitter: http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

Linkedin: http://cn.linkedin.com/in/tianlesoftware

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

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

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

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

Dave

关注

1
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
Oracle dump undo 说明

一. undo 的一些准备知识在之前的blog里有对undo segment 有说明： Current online Redo 和 Undo 损坏的处理方法 http://blog.csdn.net/tianlesoftware/artic
复制链接

扫一扫