ORA-01122 AND ORA-01210

学习BBED的过程中，突然出现了ora-01122及ora-01210错误，根据此文http://www.itpub.net/thread-1754481-1-1.html无法修复。

SQL> alter database datafile 6 online;
alter database datafile 6 online
*
ERROR at line 1:
ORA-01122: database file 6 failed verification check
ORA-01110: data file 6: '/u01/lost_it.dbf'
ORA-01210: data file header is media corrupt

 

查看alert出现如下错误：

Corrupt block relative dba: 0x01800001(file 6, block 1)
Bad header found during datafile header read
Data in bad block:
type: 11 format: 2 rdba: 0x00400001
last change scn: 0x0000.00000000 seq: 0x1 flg: 0x04
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x00000b01
check value in block header: 0xbf1
computed block checksum: 0x0
Trying reread from disk.
Reread of rdba: 0x01800001 (file 6, block 1) failed with ORA-01210

 

根据提示修改rdba_kcbh为0x01800001

BBED> p kcvfh
struct kcvfh, 676 bytes @0
struct kcvfhbfh, 20 bytes @0
ub1 type_kcbh @0 0x0b
ub1 frmt_kcbh @1 0xa2
ub1 spare1_kcbh @2 0x00
ub1 spare2_kcbh @3 0x00
ub4 rdba_kcbh @4 0x01800001

SQL> recover datafile 6;
Media recovery complete.

 

恢复成功。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/429786/viewspace-776244/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/429786/viewspace-776244/