有朋友数据文件头出现错误ORA-01122和ORA-01210等错误,数据库无法正常open。
因为平台是win,他们找我咨询win bbed,因为回老家电脑没有带,无法提供win的bbed.我通过dd部分文件头,然后在linux平台分析发现是该文件的文件头block大量坏块
bbed分析坏块情况
BBED> show all
FILE# 0
BLOCK# 1
OFFSET 0
DBA 0x00000000 (0 0,1)
FILENAME /tmp/30.dbf
BIFILE bifile.bbd
LISTFILE
BLOCKSIZE 8192
MODE Browse
EDIT Unrecoverable
IBASE Dec
OBASE Dec
WIDTH 80
COUNT 512
LOGFILE log.bbd
SPOOL No
BBED> set count 64
COUNT 64
BBED> map
File: /tmp/30.dbf (0)
Block: 1 Dba:0x00000000
------------------------------------------------------------
BBED-00400: invalid blocktype (27)
BBED> d
File: /tmp/30.dbf (0)
Block: 1 Offsets: 0 to 63 Dba:0x00000000
------------------------------------------------------------------------
1ba20000 03004400 bffd8a1d 0000000c acba0000 008f4500 00003455 fc020000
02040000 00000000 00008001 04000000 00000000 00000000 949400b4 94514005
<32 bytes per line>
BBED> set block +1
BLOCK# 2
BBED> map
File: /tmp/30.dbf (0)
Block: 2 Dba:0x00000000
------------------------------------------------------------
BBED-00400: invalid blocktype (27)
BBED> d
File: /tmp/30.dbf (0)
Block: 2 Offsets: 0 to 63 Dba:0x00000000
------------------------------------------------------------------------
1ba20000 04004400 bffd8a1d 0000000c a6e00000 008f4500 00003455 fc020000
0204e81f 00000000 0