不小心删掉oracle数据库datafiles的dbf文件的解决办法

进入>sqlplus /nolog

>connnect / as sysdba

>startup 报错信息如下：

ERROR at line 1: ORA-01157: cannot data file 6 - see DBWR trac ORA-01110: data file 6: '/home/oracle/oradata/orcl/db_outo.DBF'

具体步骤如下：

1、ALTER SYSTEM SET "_allow_resetlogs_corruption"=TRUE SCOPE=SPFILE;

System altered.

2、shutdown immediate;

ora-01109:数据库未打开
已经卸载数据库
ORACLE例程已关闭

3、startup mount;

ORACLE 例程已经启动
Total System Global Area 61236838 bytes
Fixed Size 125042 bytes
Variable Size 22230106 bytes
Database Buffers 38168166 bytes
Redo Buffers 713523 bytes
数据库装载完毕

4、alter database datafile '/home/oracle/oradata/orcl/db_outo.DBF'offline drop;
数据库已更改

5、alter database open;

数据库已更改
6、再次连接 connectgdqy/gdqy123@orcl
已连接
例程已连接上，问题得以解