Oracle ORA-01157报错"cannot identify/lock data file"解决
来源:互联网 发布:linux . 编辑:程序博客网 时间:2024/05/02 01:01
既然出现报错的几个dbf文件已经不用,则解决办法相对简单,只要将对应的数据文件删除,并继续删除对应新增的表空间即可。操作过程如下:
SQL> shutdown immediate;
SQL> startup mount;
SQL> select file#,name,status from v$datafile;
SQL> alter database datafile '/tmp/test.dbf' offline drop; //此处若不加drop会报错
再次查看v$datafile表会发现对应的几个dbf文件状态由ONLINE变为RECOVER
SQL> select * from v$tablespace;
SQL> drop tablespace test including contents cascade constraints;
......
删除完毕,再次执行startup成功。
阅读全文
0 0
- ORA-01157报错"cannot identify/lock data file"解决
- Oracle ORA-01157报错"cannot identify/lock data file"解决
- oracle启动报错ORA-01157: cannot identify/lock data file 7
- ORA-01157: cannot identify/lock data file
- oracle 启动时出现ORA-01157: cannot identify/lock data和ORA-01110: data file 错误
- ORA-01157报错"cannot identify/lock data file" ORA-01219:database not open:queries allowed on fixed
- ORA-01157: cannot identify/lock data file - see DBWR tracefile
- ORA-01157: cannot identify/lock data file 7
- 【续】ORA-01157: cannot identify/lock data file 6 - see DBWR trace file ORA-01110: 解决方法
- 【精】ORA-01157: cannot identify/lock data file 6 - see DBWR trace file ORA-01110: 解决方法
- ORA-01157: cannot identify/lock data file 27 - see DBWR trace file
- ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
- ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
- ORA-01157: cannot identify/lock data file 6 – see DBWR trace file
- ORA-01157: cannot identify/lock data file %s - see DBWR trace file的处理
- ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
- ORA-01157: cannot identify/lock data file n 故障一例
- ORA-1157, cannot identify/lock data file - see DBWR trace file
- C#使用ProtoBuf进行Socket通信
- 第一篇就从solr谈起
- java作业16027240048
- 【1701H1】【穆晨】【171031】连续第二十一天总结
- 关于xftp上传文件状态错误的解决
- Oracle ORA-01157报错"cannot identify/lock data file"解决
- 彻底理解PCA(Principal Component Analysis)主成分分析
- 利用Cookie、Session写的登录页面、成功页面、退出页面
- PyQt笔记003——简单的信号与槽
- php的select where定位查询
- Purifying Machine UVA
- 【第二部分-图像处理】第1章 Opencv图像处理入门
- 利用PS抠出水印字并添加到图片
- bzoj4565 [Haoi2016]字符合并 (区间DP + 状压DP)