--获取600错误最后一个参数 8388713的含义，到底是哪个文件，哪个数据块
SQL> select dbms_utility.DATA_BLOCK_ADDRESS_FILE(8388713) file_id,dbms_utility.DATA_BLOCK_ADDRESS_BLOCK(8388713) block_id from dual;
FILE_ID BLOCK_ID
---------- ----------
2 105
可见是和回滚段 有关，也证明我前面的分析，2662就是和数据一致性有关，即数据恢复
SQL> select owner,segment_name,segment_type from dba_extents where file_id=2 and block_id=105;
OWNER SEGMENT_NAME SEGMENT_TYPE
------------------------------ --------------------------------------------------------------------------------- ------------------
SYS _SYSSMU7$
--从另一个角度分析可见上述报错涉及的回滚段共计占用66个数据块
SQL> select count(*) from dba_extents where segment_name='_SYSSMU7$'
2 ;
COUNT(*)
----------
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
Extent Number:10 Commit Time: 1442068177
Extent Number:11 Commit Time: 1442068178
Extent Number:12 Commit Time: 1442068179
Extent Number:13 Commit Time: 1442068180
Extent Number:14 Commit Time: 1442068180
Extent Number:15 Commit Time: 1442068181
Extent Number:16 Commit Time: 1442068205
Extent Number:17 Commit Time: 1442068236
Extent Number:18 Commit Time: 1442068255
Extent Number:19 Commit Time: 1442068290
Extent Number:20 Commit Time: 1442068335
Extent Number:21 Commit Time: 1442068385
Extent Number:22 Commit Time: 1442068427
Extent Number:23 Commit Time: 1442068450
Extent Number:24 Commit Time: 1442068513
Extent Number:25 Commit Time: 1442068541
Extent Number:26 Commit Time: 1442068634
Extent Number:27 Commit Time: 1442068634
Extent Number:28 Commit Time: 1442068634
Extent Number:29 Commit Time: 1442068667
Extent Number:30 Commit Time: 1442068689
Extent Number:31 Commit Time: 1442068689
Extent Number:32 Commit Time: 1442068691
Extent Number:33 Commit Time: 1442068739
Extent Number:34 Commit Time: 1442068759
Extent Number:35 Commit Time: 1442068764
Extent Number:36 Commit Time: 1442068770
Extent Number:37 Commit Time: 1442068770
Extent Number:38 Commit Time: 1442068770
Extent Number:39 Commit Time: 1442068795
Extent Number:40 Commit Time: 1442068830
Extent Number:41 Commit Time: 1442068831
Extent Number:42 Commit Time: 1442068831
Extent Number:43 Commit Time: 1442068834
Extent Number:44 Commit Time: 1442068837
Extent Number:45 Commit Time: 1442068837
Extent Number:46 Commit Time: 1442068837
Extent Number:47 Commit Time: 1442068839
Extent Number:48 Commit Time: 1442068840
Extent Number:49 Commit Time: 1442068840
Extent Number:50 Commit Time: 1442068842
Extent Number:51 Commit Time: 1442068872
Extent Number:52 Commit Time: 1442068872
Extent Number:53 Commit Time: 1442068872
Extent Number:54 Commit Time: 1442068873
Extent Number:55 Commit Time: 1442068914
Extent Number:56 Commit Time: 1442068952
Extent Number:57 Commit Time: 1442068956
Extent Number:58 Commit Time: 1442068957
Extent Number:59 Commit Time: 1442068957
Extent Number:60 Commit Time: 1442068958
Extent Number:61 Commit Time: 1442068958
Extent Number:62 Commit Time: 1442068961
Extent Number:63 Commit Time: 1442068975
Extent Number:64 Commit Time: 1442069033
Extent Number:65 Commit Time: 1448938830
--trn ctl是事务表，和事务相关,事务表也有scn
TRN CTL:: seq: 0x0046 chd: 0x0001 ctl: 0x002a inc: 0x00000000 nfb: 0x0001
mgc: 0x8201 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)
uba: 0x00800158.0046.37 scn: 0x0000.028f6415 --scn
Version: 0x01