忘记做备份,物理删除了数据文件dmptest01.dbf,然后数据库起不来了
SQL*Plus: Release 10.2.0.4.0 - Production on Sat Dec 15 09:08:34 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> startup mount
ORACLE instance started.
Total System Global Area 373293056 bytes
Fixed Size 1267572 bytes
Variable Size 104859788 bytes
Database Buffers 264241152 bytes
Redo Buffers 2924544 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01122: database file 7 failed verification check
ORA-01110: data file 7: '/u01/oracle/oradata/ORCL/dmptest01.dbf'
ORA-01251: Unknown File Header Version read for file number 7
SQL> alter database datafile 7 offline drop;
Database altered.
SQL> alter database open;
Database altered.