oracle 启动时出现ORA-01157: cannot identify/lock data和ORA-01110: data file 错误
来源:互联网 发布:自学舞蹈的软件 编辑:程序博客网 时间:2024/05/02 01:06
SQL> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance started.
Total System Global Area 422670336 bytes
Fixed Size 1336960 bytes
Variable Size 314575232 bytes
Database Buffers 100663296 bytes
Redo Buffers 6094848 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/bk/dba_tablespaces/ts3.dbf'
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/bk/dba_tablespaces/ts3.dbf'
SQL> alter database datafile '/bk/dba_tablespaces/ts3.dbf' offline drop;
Database altered.
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: '/bk/dba_tablespaces/ts6.dbf'
SQL> alter database datafile '/bk/dba_tablespaces/ts6.dbf' offline drop;
Database altered.
SQL> alter database open
2 ;
Database altered.
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 422670336 bytes
Fixed Size 1336960 bytes
Variable Size 314575232 bytes
Database Buffers 100663296 bytes
Redo Buffers 6094848 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/bk/dba_tablespaces/ts3.dbf'
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/bk/dba_tablespaces/ts3.dbf'
SQL> alter database datafile '/bk/dba_tablespaces/ts3.dbf' offline drop;
Database altered.
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: '/bk/dba_tablespaces/ts6.dbf'
SQL> alter database datafile '/bk/dba_tablespaces/ts6.dbf' offline drop;
Database altered.
SQL> alter database open
2 ;
Database altered.
- oracle 启动时出现ORA-01157: cannot identify/lock data和ORA-01110: data file 错误
- ORA-01157: cannot identify/lock data file
- oracle启动报错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 - see DBWR tracefile
- ORA-01157报错"cannot identify/lock data file"解决
- ORA-01157: cannot identify/lock data file 7
- Oracle ORA-01157报错"cannot identify/lock data file"解决
- 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-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
- 求四个数中的最大最小值
- hdu 2143
- 反调试技术(以OD为例附核心原代码
- Sql 数据库基础语句(二)
- poj2594 Treasure Exploration 最小路径覆盖=顶点数-最大匹配数
- oracle 启动时出现ORA-01157: cannot identify/lock data和ORA-01110: data file 错误
- HTML: <a> target属性以及如何在JS实现相同效果
- JSP内置对象
- configure: error: cannot guess build type; you must specify one解决办法
- C++派生类的复制控制
- How to troubleshoot SQL Server performance issues
- IOS block dispatch_queue
- Number Sequence hdu 1005 一个有技巧的题目
- 九月十月百度,迅雷,华为,阿里巴巴,最新校招笔试面试五十题