[oracle@localhost ~]$ sqlplus / as sysdbaadmin管理员组文章数量:1130349
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 20 09:27:31 2017
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 2.6844E+10 bytes
Fixed Size 2069472 bytes
Variable Size 8925482016 bytes
Database Buffers 1.7901E+10 bytes
Redo Buffers 14704640 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/oradata/test01.dbf
解决办法:
1)shutdown immediate;
2)startup mount
3)alter database datafile '/oradata/test.dbf' offline drop;
4)关闭数据库
5)重新启动数据库,并执行如下语句:
drop tablespace test including contents cascade constraints;
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 20 09:27:31 2017
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 2.6844E+10 bytes
Fixed Size 2069472 bytes
Variable Size 8925482016 bytes
Database Buffers 1.7901E+10 bytes
Redo Buffers 14704640 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/oradata/test01.dbf
解决办法:
1)shutdown immediate;
2)startup mount
3)alter database datafile '/oradata/test.dbf' offline drop;
4)关闭数据库
5)重新启动数据库,并执行如下语句:
drop tablespace test including contents cascade constraints;
版权声明:本文标题:oracle启动报错ORA-01157: cannot identifylock data file 7 - see DBWR trace file ORA-01110: data file 7: 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://it.en369.cn/jiaocheng/1763735474a2958846.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。


发表评论