ORA-01157: cannot identify/lock data file 7
来源:互联网 发布:餐饮进销存软件 编辑:程序博客网 时间:2024/05/02 04:23
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/oradata/test01.dbf'
ORA-01110: data file 7: '/oradata/test01.dbf'
问题出现原因:
不小心手动删除了数据库文件,启动数据库报错
解决办法:
sqlplus / as sysdba
startup mount
select file#,name status from v$datafile;
alter database datafile '/oradata/test01.dbf' offline drop;
关闭数据库后重新启动,启动成功
阅读全文
0 0
- ORA-01157: cannot identify/lock data file
- ORA-01157: cannot identify/lock data file 7
- ORA-01157: cannot identify/lock data file - see DBWR tracefile
- ORA-01157报错"cannot identify/lock data file"解决
- oracle启动报错ORA-01157: cannot identify/lock data file 7
- oracle 启动时出现ORA-01157: cannot identify/lock data和ORA-01110: data file 错误
- 【续】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 故障一例
- Oracle ORA-01157报错"cannot identify/lock data file"解决
- ORA-01157报错"cannot identify/lock data file" ORA-01219:database not open:queries allowed on fixed
- ORA-1157, cannot identify/lock data file - see DBWR trace file
- NT驱动程序和WDM驱动程序的区别
- 怎样设计一个好的数据库
- unity3d与android
- Maven入门
- 如何修改一次代码就可以完成多种类型 cell 的 UITableView 增删修改顺序?
- ORA-01157: cannot identify/lock data file 7
- 联表更新
- 一种类似护盾绕圆旋转的设计
- 通过spring配置两个数据源的实现方法(一)
- BloomFilter应用与D-Lelft BloomFilter实现
- 在控制台中输入msqyl一直报ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost'错误
- HDU3829Cat VS Dog(二分图最大独立集)
- 思维导图,带你走进《西游记》人物的世界
- Hadoop集群安装配置