ORA-01157: cannot identify/lock data file 7 - see DBWR trace file

分类: 文章 • 2022-11-29 10:15:55

ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/oradata/test01.dbf'

问题出现原因：

不小心手动删除了数据库文件，启动数据库报错

解决办法:

sqlplus / as sysdba

startup mount

select file#,name status from v$datafile;

alter database datafile '/oradata/test01.dbf' offline drop;

ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
关闭数据库后重新启动，启动成功