| Offset | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | a | b | c | d | e | f | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| ||||||||||||||||||||||||||||||||||
| 00014000 | 06 | A2 | 00 | 00 | 0A | 00 | 40 | 01 | 0E | 89 | 43 | 00 | 00 | 00 | 05 | 02 | ||||||||||||||||||
| type | frmt | spare1/2_kcbh | rdba | scn | seq | flg | ||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||
| 00014010 | 00 | 00 | 00 | 00 | 01 | 00 | 17 | 00 | 54 | D2 | 00 | 00 | 0A | 89 | 43 | 00 | ||||||||||||||||||
| chkval | spare3_kcbh | typ | ? | seg/obj | csc | |||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||
| 00014020 | 00 | 00 | E8 | 1F | 02 | 00 | 03 | 00 | 00 | 00 | 00 | 00 | 04 | 00 | 0C | 00 | ||||||||||||||||||
| csc | ? | itc | ? | flg | fsl | fnx | xid | |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||
| 00014030 | 50 | 18 | 00 | 00 | 96 | 14 | 80 | 00 | B9 | 07 | 01 | 00 | 01 | 20 | 00 | 00 | ||||||||||||||||||
| xid | uba | Lck Flag | Scn/Fsc | |||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||
| 00014040 | 0E | 89 | 43 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | ||||||||||||||||||
| Scn/Fsc | 第2条itl 这里没使用 | |||||||||||||||||||||||||||||||||
|
| ||||||||||||||||||||||||||||||||||
| 00014050 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 01 | 01 | 00 | ||||||||||||||||||
| 第2条itl 这里没使用 | flag | ntab | nrow | |||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||
| 00014060 | FF | FF | 14 | 00 | 9B | 1F | 83 | 1F | 83 | 1F | 00 | 00 | 01 | 00 | 9B | 1F | ||||||||||||||||||
| frre | fsbo | fseo | avsp | tosp | offs | nrow | row offs | |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||
| 00015FF0 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 2C | 01 | 01 | 01 | 61 | 05 | 06 | 0E | 89 | ||||||||||||||||||
| fb | lb | cc | length | data | block tail | |||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||
10.1.0~lgone@ONE.LG.OK> create table a(v varchar2(4000)) TABLESPACE t;
Table created.
10.1.0~lgone@ONE.LG.OK> insert into a values('a');
1 row created.
Start dump data blocks tsn: 17 file#: 5 minblk 10 maxblk 10
buffer tsn: 17 rdba: 0x0140000a (5/10)
scn: 0x0000.0043890e seq: 0x05 flg: 0x02 tail: 0x890e0605
frmt: 0x02 chkval: 0x0000 type: 0x06=trans data
Block header dump: 0x0140000a
Object id on Block? Y
seg/obj: 0xd254 csc: 0x00.43890a itc: 2 flg: O typ: 1 - DATA
fsl: 0 fnx: 0x0 ver: 0x01
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0004.00c.00001850 0x00801496.07b9.01 --U- 1 fsc 0x0000.0043890e
0x02 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
data_block_dump,data header at 0x87e125c
===============
tsiz: 0x1fa0
hsiz: 0x14
pbl: 0x087e125c
bdba: 0x0140000a
76543210
flag=--------
ntab=1
nrow=1
frre=-1
fsbo=0x14
fseo=0x1f9b
avsp=0x1f83
tosp=0x1f83
0xe:pti[0] nrow=1 offs=0
0x12:pri[0] offs=0x1f9b
block_row_dump:
tab 0, row 0, @0x1f9b
tl: 5 fb: --H-FL-- lb: 0x1 cc: 1
col 0: [ 1] 61
end_of_block_dump
End dump data blocks tsn: 17 file#: 5 minblk 10 maxblk 10
block 坏掉了还可以报:
ORA-600 (4519) Cache layer block type is incorrect
ORA-600 (4393) Check for Type for Segment header with free list
ORA-600 (4136) Check Rollback segment block
ORA-600 (4154) Check Rollback segment block
Ora-600[kcbzpb_1],[d],[kind],[chk] gets signaled when the block got corrupted in memory.
The only way it should be bad is if a stray store into memory destroyed the header or tail.
d = blocknumber, kind= kind of corruption detected,chk = checksum flag
ora-600[3398] and ora-600[3339]
ora-600[3398] is not in oracle 8.
ora-600[3398] means it failed a verification check before writing back to disk, so it must
be an in-memory corruption.
ora-600[3339] comes with ora-1578 and means either disk corruption or in memory corruption after read.
ora-600 [3339] has been removed from 7.2+
From 7.2+ ora-600 [3398] has become ora-600 [3374] with some checks added.
2进制存储格式
ALTER SESSION SET EVENTS '10289 trace name context forever, level 1';
ALTER SESSION SET EVENTS '10289 trace name context off';
本文深入解析了Oracle数据库中数据块的结构组成及其关键操作,包括数据块大小、偏移量、类型标识、序列号、状态标志等元素的作用与意义。详细阐述了如何通过查询和修改这些属性来影响数据存储与检索过程,同时讨论了数据块损坏的检测与修复方法。文章旨在帮助数据库管理员和开发者更好地理解和操作Oracle数据库的数据存储机制。
1891

被折叠的 条评论
为什么被折叠?



