admin管理员组文章数量:1654322
解决Oracle数据库启动报错ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
ORA-01110: data file 10: ‘/u01/app/oracle/oradata/ORCL/zpzdata.dbf’
参考:
https://blog.csdn/lxpbs8851/article/details/7244670
解决方法:
SQL> shutdown immediate;
SQL> startup mount;
SQL> select file#,name,status from v$datafile;
这两个文件都是ONLINE得状态
SQL> alter database datafile ‘/u01/app/oracle/oradata/ORCL/zpzdata.dbf’ offline drop;
Database altered.
SQL>
SQL> alter database datafile ‘/u01/app/oracle/oradata/ORCL/zpzidx.dbf’ offline drop;
Database altered.
将文件状态由ONLINE变为RECOVER;
SQL> select * from v$tablespace;
SQL> alter database open;
Database altered.
(drop tablespace test includingcontents cascade constraints;将test替换为相应得表空间名)
SQL> drop tablespace ZPZ_DATA including contents cascade constraints;
Tablespace dropped.
SQL> drop tablespace ZPZ_IDX including contents cascade constraints;
Tablespace dropped.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 3221222464 bytes
Fixed Size 8901696 bytes
Variable Size 654311424 bytes
Database Buffers 2550136832 bytes
Redo Buffers 7872512 bytes
Database mounted.
Database opened.
SQL> exit
本文标签: 数据库identifyLockORACLEORA
版权声明:本文标题:解决Oracle数据库ORA-01157: cannot identifylock data file 10 - see DBWR trace file ORA-01110: data file 1 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://www.elefans.com/dianzi/1729649708a1208893.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论