oracle data文件格式,Oracle datafile block 格式 说明

三. block坏掉了还可以报如下的错误

ORA-600 (4519) Cache layer block type isincorrect

ORA-600 (4393) Check for Type for Segmentheader with free list

ORA-600 (4136) Check Rollback segment block

ORA-600 (4154) Check Rollback segment block

Ora-600[kcbzpb_1],[d],[kind],[chk] getssignaled when the block got corrupted in memory. The only way it should be badis if a stray store into memory destroyed the header or tail.

d = blocknumber, kind= kind of corruptiondetected,chk = checksum flag

ora-600[3398] and ora-600[3339]

ora-600[3398] is not in Oracle 8.

ora-600[3398] means it failed averification check before writing back to disk, so it must be an in-memory corruption.

ora-600[3339] comes with ora-1578 and meanseither 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进制存储格式：

SQL>ALTER SESSION SET EVENTS'10289 trace name context forever, level 1';

SQL> ALTER SESSION SETEVENTS '10289 trace name context off';