ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-01122 AND ORA-01210

ORA-01122 AND ORA-01210

原创 Linux操作系统 作者:wailon 时间:2013-11-10 20:48:16 0 删除 编辑

学习BBED的过程中,突然出现了ora-01122ora-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_kcbh0x01800001

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-11-08

  • 博文量
    51
  • 访问量
    294580