删除数据库文件之后出现的错误

直接用rm命令删除了数据库文件。

重新启动数据库服务时

SQL> startup;

ORACLE instance started.

 

Total System Global Area 1703624704 bytes

Fixed Size                  2170464 bytes

Variable Size            1056965024 bytes

Database Buffers          637534208 bytes

Redo Buffers                6955008 bytes

Database mounted.

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

ORA-01110: data file 5: '/opt/oracle/oradata/orcl/CSG_EHVGZ.dbf'

 

解决方法：

SQL> alter database datafile 5 offline drop;

Database altered.

SQL> startup;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 1703624704 bytes
Fixed Size                  2170464 bytes
Variable Size            1056965024 bytes
Database Buffers          637534208 bytes
Redo Buffers                6955008 bytes
Database mounted.
Database opened.