ORA-01157报错"cannot identify/lock data file" ORA-01219:database not open:queries allowed on fixed

来源：互联网发布：九寨沟几月知乎编辑：程序博客网时间：2024/04/19 00:21

SQL> startup
Database mounted.
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/home/oracle/user1.mdf''

shutdown immediate;

SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/home/oracle/user1.mdf'

SQL> alter database datafile '/home/oracle/user1.mdf' offline drop;

Database altered.

SQL> alter database open;

Database altered.

查询是否有该表空间文件

SQL> select tablespace_name,status,contents from dba_tablespaces where tablespace_name='user1';

no rows selected

参考文档

http://blog.sina.com.cn/s/blog_3cba7ec10100y0u1.html

http://blog.sina.com.cn/s/blog_6efbe0220100v1qj.html

http://www.linuxidc.com/Linux/2012-11/74151p2.htm