admin管理员组

文章数量:1654021

删除了DBF文件,遇到

ORA-01157: cannot identify/lock data file 101 – see DBWR trace file
ORA-01110: data file 101: ‘xxxx.dbf’

使用以下方式可以进到到OPEN 状态

alter database datafile 101 offline drop;

SQL> startup force
ORACLE instance started.


Total System Global Area  838860800 bytes
Fixed Size                  2076400 bytes
Variable Size             218104080 bytes
Database Buffers          612368384 bytes
Redo Buffers                6311936 bytes
Database mounted.
Database opened.

本文标签: identifyORAfileDataLock