admin管理员组

文章数量:1130349

SQL> shutdown
ORA-01109: database not open
Database dismounted.

ORACLE instance shut down.


SQL> startup
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.
SQL> shutdown
ORA-01109: database not open
Database dismounted.

ORACLE instance shut down.


SQL> startup
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.

本文标签： 启动时错误ORAOracleIdentify

版权声明：本文标题：oracle 启动时出现ORA-01157: cannot identifylock data和ORA-01110: data file 错误 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://it.en369.cn/jiaocheng/1763736254a2958913.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。