新建实例名为interlib的实例,并且删除orcl10g实例,并且设置系统默认SID为interlib.然后启动数据库
SQL> startup
ORACLE instance started.
Total System Global Area 1174405120 bytes
Fixed Size 2020288 bytes
Variable Size 301993024 bytes
Database Buffers 855638016 bytes
Redo Buffers 14753792 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\INTERLIB\SYSTEM01.DBF'
查看警告日志
ALTER DATABASE OPEN
Mon Jun 2 23:20:36 2014
Errors in file /app/oracle/admin/interlib/bdump/interlib_dbw0_3146.trc:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\INTERLIB\SYSTEM01.DBF'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
查看警告日志中提到的trc文件报错信息:
*** SERVICE NAME:() 2014-06-02 23:20:36.178
*** SESSION ID:(167.1) 2014-06-02 23:20:36.178
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\INTERLIB\SYSTEM01.DBF'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\INTERLIB\UNDOTBS01.DBF'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\INTERLIB\SYSAUX01.DBF'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
如何修复
------解决方案--------------------
说明你这些数据文件都找不到了, 那这些文件物理上有没有?
------解决方案--------------------
会不会是删错了啊。
看看文件在不在。