oracle 启动时出现ORA-01157: cannot identify/lock data和ORA-01110: data file 错误

最新推荐文章于 2023-03-28 10:51:20 发布

原创最新推荐文章于 2023-03-28 10:51:20 发布 · 3.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #ORA-01157 #ORA-01110

本文详细记录了一次数据库遇到ORA-01109错误并最终成功恢复的过程。从关闭数据库、启动数据库、识别数据文件错误、离线删除损坏的数据文件，到重新打开数据库的整个故障排查步骤被详尽阐述。通过此案例，读者可以了解如何应对数据库中常见的数据文件识别和锁定问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SQL> shutdown
ORA-01109: database not open
Database dismounted.

ORACLE instance shut down.

SQL> startup
ORACLE instance started.
Total System Global Area 422670336 bytes
Fixed Size 1336960 bytes
Variable Size 314575232 bytes
Database Buffers 100663296 bytes
Redo Buffers 6094848 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/bk/dba_tablespaces/ts3.dbf'

SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/bk/dba_tablespaces/ts3.dbf'

SQL> alter database datafile '/bk/dba_tablespaces/ts3.dbf' offline drop;
Database altered.

SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: '/bk/dba_tablespaces/ts6.dbf'

SQL> alter database datafile '/bk/dba_tablespaces/ts6.dbf' offline drop;
Database altered.

SQL> alter database open
2 ;
Database altered.