解决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