admin管理员组

文章数量:1130349

[oracle@localhost ~]$ sqlplus / as sysdba


SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 20 09:27:31 2017


Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to an idle instance.


SQL> startup
ORACLE instance started.


Total System Global Area 2.6844E+10 bytes
Fixed Size    2069472 bytes
Variable Size 8925482016 bytes
Database Buffers 1.7901E+10 bytes
Redo Buffers   14704640 bytes
Database mounted.

ORA-01157: cannot identify/lock data file 7 - see DBWR trace file

ORA-01110: data file 7: '/oradata/test01.dbf


解决办法:

1)shutdown immediate;

2)startup mount

3)alter database datafile '/oradata/test.dbf' offline drop; 

4)关闭数据库

5)重新启动数据库,并执行如下语句:

drop tablespace test including contents cascade constraints;





[oracle@localhost ~]$ sqlplus / as sysdba


SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 20 09:27:31 2017


Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to an idle instance.


SQL> startup
ORACLE instance started.


Total System Global Area 2.6844E+10 bytes
Fixed Size    2069472 bytes
Variable Size 8925482016 bytes
Database Buffers 1.7901E+10 bytes
Redo Buffers   14704640 bytes
Database mounted.

ORA-01157: cannot identify/lock data file 7 - see DBWR trace file

ORA-01110: data file 7: '/oradata/test01.dbf


解决办法:

1)shutdown immediate;

2)startup mount

3)alter database datafile '/oradata/test.dbf' offline drop; 

4)关闭数据库

5)重新启动数据库,并执行如下语句:

drop tablespace test including contents cascade constraints;





本文标签: 报错IdentifyOracleORALock