大家好,
今天开启Oracle碰到一个非常棘手的问题,sqlplus / as sysdba进入SQL后,执行
SQL>startup
提示如下错误信息:
ORACLE instance started.Total System Global Area 285212672 bytes
Fixed Size 1218968 bytes
Variable Size 188745320 bytes
Database Buffers 88080384 bytes
Redo Buffers 7168000 bytes
Database mounted.
ORA-01122: database file 27 failed verification check
ORA-01110: data file 27: '/u01/app/oracle/oradata/deptmanage/dmcurrdat.dbf'
ORA-01251: Unknown File Header Version read for file number 27我认为是非正常的关闭数据库导致的问题,请问要如何解决?我的OS是RHEL 4。
项目小组的人还等着用ORACLE编译代码呢,特别急,望高人指点,小弟感激不尽!!!
今天开启Oracle碰到一个非常棘手的问题,sqlplus / as sysdba进入SQL后,执行
SQL>startup
提示如下错误信息:
ORACLE instance started.Total System Global Area 285212672 bytes
Fixed Size 1218968 bytes
Variable Size 188745320 bytes
Database Buffers 88080384 bytes
Redo Buffers 7168000 bytes
Database mounted.
ORA-01122: database file 27 failed verification check
ORA-01110: data file 27: '/u01/app/oracle/oradata/deptmanage/dmcurrdat.dbf'
ORA-01251: Unknown File Header Version read for file number 27我认为是非正常的关闭数据库导致的问题,请问要如何解决?我的OS是RHEL 4。
项目小组的人还等着用ORACLE编译代码呢,特别急,望高人指点,小弟感激不尽!!!
应该是非法关闭数据库造成的数据文件损坏的
1置为离线
alter database datafile '/u01/app/oracle/oradata/deptmanage/dmcurrdat.dbf' offline2 打开
alter database open3 恢复
recover datafile '/u01/app/oracle/oradata/deptmanage/dmcurrdat.dbf' 4 置为在线
alter database datafile '/u01/app/oracle/oradata/deptmanage/dmcurrdat.dbf' online