UNT(*)
?----------
? ? ? ? 66
?SQL> select distinct block_id from dba_extents where segment_name='_SYSSMU7$' order by 1;
? BLOCK_ID
?----------
? ? ? ? 105
? ? ? ? 113
? ? ? ? 249
? 中间略
? ? 37065
? ? ? 37257
? ? ? 38537
? ? ? 39945
?66 rows selected.
--既然是2号文件的105数据块报错，DUMP这个数据进行分析
Start dump data blocks tsn: 1 file#: 2 minblk 105 maxblk 105
?buffer tsn: 1 rdba: 0x00800069 (2/105)
?scn: 0x0001.00000e73 seq: 0x02 flg: 0x00 tail: 0x0e732602? ---scn
?frmt: 0x02 chkval: 0x0000 type: 0x26=KTU SMU HEADER BLOCK? ---可见是回滚段头块
Hex dump of block: st=0, typ_found=1
? Extent Control Header
? -----------------------------------------------------------------
? Extent Header:: spare1: 0? ? ? spare2: 0? ? ? #extents: 66? ? #blocks: 3647?
? ? ? ? ? ? ? ? ? last map? 0x00000000? #maps: 0? ? ? offset: 4080?
? ? ? Highwater::? 0x00800158? ext#: 4? ? ? blk#: 7? ? ? ext size: 8? ?
? #blocks in seg. hdr's freelists: 0? ?
? #blocks below: 0? ?
? mapblk? 0x00000000? offset: 4? ?
? ? ? ? ? ? ? ? ? ? Unlocked
? ? ? Map Header:: next? 0x00000000? #extents: 66? obj#: 0? ? ? flag: 0x40000000
? ? ? ---extent map控制extent分配的情况，对应dba_extents的extents总数
? Extent Map
? -----------------------------------------------------------------
? ? 0x0080006a? length: 7? ?
? ? 0x00800071? length: 8? ?
? ? 0x008000f9? length: 8? ?
? ? 0x00800131? length: 8? ?
? ? 0x00800151? length: 8? ?
? ? 0x00800159? length: 8? ?
? ? 0x008001e1? length: 8? ?
? ? 0x00800201? length: 8? ?
? ? 0x008002c1? length: 8? ?
? ? 0x008002e9? length: 8? ?
? ? 0x00800329? length: 8? ?
? ? 0x00800381? length: 8? ?
? ? 0x008003c1? length: 8? ?
? ? 0x008003e9? length: 8? ?
? ? 0x00800449? length: 8? ?
? ? 0x00800461? length: 8? ?
? ? 0x00800509? length: 128?
? ? 0x00800a89? length: 128?
? ? 0x00801309? length: 128?
? ? 0x00801709? length: 128?
? ? 0x00801c89? length: 128?
? ? 0x00802109? length: 128?
? ? 0x00802689? length: 128?
? ? 0x00802e89? length: 128?
? ? 0x00803109? length: 128?
? ? 0x00803689? length: 128?
? ? 0x00803b09? length: 128?
? ? 0x00804f89? length: 128?
? ? 0x00805009? length: 128?
? ? 0x00805089? length: 128?
? ? 0x00805509? length: 128?
? ? 0x00806089? length: 128?
? ? 0x00806109? length: 128?
? ? 0x00806209? length: 128?
? ? 0x008068c1? length: 8? ?
? ? 0x008068c9? length: 8? ?
? ? 0x008068d9? length: 8? ?
? ? 0x008068f1? length: 8? ?
? ? 0x008068f9? length: 8? ?
? ? 0x00806909? length: 128?
? ? 0x00806e89? length: 128?
? ? 0x00807789? length: 8? ?
? ? 0x00807791? length: 8? ?
? ? 0x008077a9? length: 8? ?
? ? 0x008077b1? length: 8? ?
? ? 0x008077f9? length: 8? ?
? ? 0x00807801? length: 8? ?
? ? 0x00807a09? length: 8? ?
? ? 0x00807a11? length: 8? ?
? ? 0x00807a51? length: 8? ?
? ? 0x00807a71? length: 8? ?
? ? 0x00807a89? length: 128?
? ? 0x00808199? length: 8? ?
? ? 0x008081b9? length: 8? ?
? ? 0x008081c9? length: 8? ?
? ? 0x00808309? length: 128?
? ? 0x00808789? length: 128?
? ? 0x00808e21? length: 8? ?
? ? 0x00808e29? length: 8? ?
? ? 0x00809089? length: 8? ?
? ? 0x00809091? length: 8? ?
? ? 0x00809099? length: 8? ?
? ? 0x008090c9? length: 8? ?
? ? 0x00809189? length: 128?
? ? 0x00809689? length: 128?
? ? 0x00809c09? length: 128?
?
? Retention Table
? -----------------------------------------------------------
? Extent Number:0? Commit Time: 1448938837
? Extent Number:1? Commit Time: 1448938849
? Extent Number:2? Commit Time: 1448948373
? Extent Number:3? Commit Time: 1448951574
? Extent Number:4? Commit Time: 1448960452
? Extent Number:5? Commit Time: 1442068172
? Extent Number:6? Commit Time: 1442068173
? Extent Number:7? Commit Time: 1442068174
? Extent Number:8? Commit Time: 1442068175
? Extent Number:9? Commit Time: 1442068176
? Exten