有一個(gè)數(shù)據(jù)庫硬盤空間滿了，查看發(fā)現(xiàn)一個(gè)dbf超大，并且不在規(guī)定的路徑下，知道是一個(gè)非重要數(shù)據(jù)文件，于是刪除。

后來重啟數(shù)據(jù)庫時(shí)，

SQL> startup
ORACLE instance started.

Total System Global Area? 285212672 bytes
Fixed Size??? ??? ??? 1218992 bytes
Variable Size??? ??? ?? 96470608 bytes
Database Buffers??? ? 184549376 bytes
Redo Buffers??? ??? ??? 2973696 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 2 – see DBWR trace file
ORA-01110: data file 2: ‘/opt/oracle/oradata/myora/undotbs01.dbf’;

?

處理辦法：

SQL> startup mount;
ORACLE instance started.

Total System Global Area? 285212672 bytes
Fixed Size??? ??? ??? 1218992 bytes
Variable Size??? ??? ?? 96470608 bytes
Database Buffers??? ? 184549376 bytes
Redo Buffers??? ??? ??? 2973696 bytes
Database mounted.

SQL> alter database datafile ?‘/opt/oracle/oradata/myora/undotbs01.dbf’ ?offline drop;

Database altered.

SQL>?alter database open;

語句已處理。

最后將表空間drop，再重建就好了。

Oracle dbf文件刪除后，啟動(dòng)服務(wù)ORA-01157問題