ORA-01157:cannot identify/lock data file 6 - see DBWR trace file ORA-01110:data file 6:‘XX/X/X.dbf‘

最新推荐文章于 2025-09-09 13:51:03 发布

原创最新推荐文章于 2025-09-09 13:51:03 发布 · 366 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #数据库

Oracle 专栏收录该内容

7 篇文章

订阅专栏

在尝试启动Oracle数据库时遇到ORA-01157和ORA-01110错误，涉及数据文件6(/home/oracle/watch_dog1.dbf)。通过将数据文件6设置为离线并重新打开数据库来解决了问题。

SQL> startup;
ORACLE instance started.

Total System Global Area 1670221824 bytes
Fixed Size                  2253824 bytes
Variable Size            1291848704 bytes
Database Buffers          369098752 bytes
Redo Buffers                7020544 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/home/oracle/watch_dog1.dbf'


SQL> alter database datafile 6 offline drop;

Database altered.

SQL> alter database open;

Database altered.

SQL> SQL> startup;