【无标题】

解决Oracle数据库ORA-01157: cannot identify/lock data file 10 - see DBWR trace file ORA-01110: data file 1

解决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.net/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
————————————————
版权声明：本文为CSDN博主「大大愚」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/dayuuu/article/details/105958026