SQL> startup
ORACLE instance started.Total System Global Area 795127808 bytes
Fixed Size 1302848 bytes
Variable Size 494931648 bytes
Database Buffers 293601280 bytes
Redo Buffers 5292032 bytes
Database mounted.
ORA-01122: database file 11 failed verification check
ORA-01110: data file 11: '/opt/XXX/dump/MEPACKTBS.dbf'
ORA-01251: Unknown File Header Version read for file number 11
ORACLE instance started.Total System Global Area 795127808 bytes
Fixed Size 1302848 bytes
Variable Size 494931648 bytes
Database Buffers 293601280 bytes
Redo Buffers 5292032 bytes
Database mounted.
ORA-01122: database file 11 failed verification check
ORA-01110: data file 11: '/opt/XXX/dump/MEPACKTBS.dbf'
ORA-01251: Unknown File Header Version read for file number 11
解决方案 »
- 求教关于SQL的查询
- 小弟最近在学习ORACLE ,从官网上上下载了ORACLE 11,没有注册码,不注册可以吗?
- 关于新老系统数据迁移,请大家帮忙
- 问: 在Linux9.0下安装Oracle9.2.0的时候遇到的问题?
- 游标SQL语句,未报错,但执行后却没有效果????????
- imp的错误,别人的oracle数据库EXP出来的.DMP文件,导入失败?
- 怎样包调包??????
- (急)oracle817启动后,登陆sqlplus时,出现‘共享内存不存在’的错误,如何解决?
- 急!求救!Oracle 控制文件损坏,ORACLE启动后报ORA-01034错误,如何解决?在线等待。
- weblogic 出现如下错误是什么原因
- oracle里面同时删除?
- JSP程序中实现oracle 数据库备份
Symptoms
Corruption reported while reading datafile header.
Alert log shows messages like:
ORA-01171: datafile 8 going offline due to error advancing checkpoint
ORA-01122: database file 8 failed verification check
ORA-01110: data file 8: '/oracle/test_lob12.dbf'
ORA-01251: Unknown File Header Version read for file number 8
Cause
Corrupted file header.
This could be caused due to missed read or write or hardware problem or process external to oracle
overwriting the information in file header.
Solution
To Solve the problem :-
1. The database needs to be in Archive log mode.
2. You need to have all the Archive log file from the time the datafile was created .
Steps to be followed
====================
Step1 :-
Take the problematic datafile offline.
SQL> Alter database datafile '/opt/oracle/oradata/STAPLES/datafile/block01.dbf' offline;
Database altered.SQL> alter database open;
Database altered.Step 2:-
Issue the following command to re-create the file :SQL> Alter database create datafile '/opt/oracle/oradata/STAPLES/datafile/block01.dbf';
Database altered.Step 3:-
Start applying the archive log file to recreate datafile.SQL> Recover datafile '/opt/oracle/oradata/STAPLES/datafile/block01.dbf';
ORA-00279: change 931981365 generated at 11/05/2008 11:16:04 needed for thread 1
ORA-00289: suggestion : /archivelogpath/1_1156_667734786.dbf
ORA-00280: change 931981365 for thread 1 is in sequence #1156Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00279: change 931981489 generated at 11/05/2008 11:16:10 needed for thread 1
ORA-00289: suggestion : /archivelogpath/1_1157_667734786.dbf
ORA-00280: change 931981489 for thread 1 is in sequence #1157
ORA-00278: log file '/archivelogpath/1_1156_667734786.dbf' no longer needed for this recoverySpecify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 931981564 generated at 11/05/2008 11:16:22 needed for thread 1
ORA-00289: suggestion : /archivelogpath/1_1158_667734786.dbf
ORA-00280: change 931981564 for thread 1 is in sequence #1158
ORA-00278: log file '/archivelogpath/1_1157_667734786.dbf' no longer needed for this recoveryLog applied.
Media recovery complete.Step 4:-
When the recovery is finished, bring the datafile online.SQL> Alter database datafile '/opt/oracle/oradata/STAPLES/datafile/block01.dbf' online;
Database altered.SQL> select count(*) from daimin.test;
COUNT(*)
----------
14936