[描述]
Errors in file e:\oracle\admin\eastday\bdump\eastday_dbw0_5984.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: 'E:\ORACLE\ORADATA\EASTDAY\TEMP01.DBF'
ORA-27041: unable to open file
OSD-04002: 无法打开文件
O/S-Error: (OS 2) The system cannot find the file specified.
[处理]
SQL> startup mount
ORACLE 例程已经启动。
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
数据库装载完毕。
SQL> alter database tempfile'e:\oracle\oradata\ora\temp01.dbf' offline;
数据库已更改。
SQL> alter database tempfile'e:\oracle\oradata\ora\temp01.dbf' drop;
数据库已更改。
SQL> alter database open;
数据库已更改。
SQL> alter tablespace temp add tempfile'e:\oracle\oradata\ora\temp01.dbf' size 40M reuse autoextend on next 640K maxsize unlimited;
表空间已更改。