admin管理员组

文章数量:1654386

解决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://m.elefans.com/dianzi/1729649708a1208893.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。