数据文件在物理层面被删除导致数据库打不开

新建一个表空间,一个数据文件    #没有备份
create tablespace T datafile '/oradata/arch/huyuw.dbf' size 50M;
进入/oradata/arch/下用rm -rf huyuw.dbf 删除后导致数据库打不开




SQL> startup
ORACLE instance started.


Total System Global Area 1068937216 bytes
Fixed Size                  2260088 bytes
Variable Size             864027528 bytes
Database Buffers          197132288 bytes
Redo Buffers                5517312 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/oradata/arch/huyuw.dbf'






SQL> select * from v$recover_file;


     FILE# ONLINE  ONLINE_
---------- ------- -------
ERROR                                                                CHANGE#
----------------------------------------------------------------- ----------
TIME
---------
         5 ONLINE  ONLINE
FILE NOT FOUND                                                             0


SQL> set lines 300  ---->相当于拉长
SQL> /


     FILE# ONLINE  ONLINE_ ERROR                                                                CHANGE# TIME
---------- ------- ------- ----------------------------------------------------------------- ---------- ---------
         5 ONLINE  ONLINE  FILE NOT FOUND                                                             0




SQL> select name from v$datafile;


NAME
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/oradata/DG1/datafile/o1_mf_system_c8wd468f_.dbf
/oradata/DG1/datafile/o1_mf_sysaux_c8wd46ck_.dbf
/oradata/DG1/datafile/o1_mf_undotbs1_c8wd46cp_.dbf
/oradata/DG1/datafile/o1_mf_users_c8wd46dd_.dbf
/oradata/arch/huyuw.dbf






SQL> alter database datafile 5 offline;  ---> offline掉   也可以用路径加名称（'/oradata/arch/huyuw.dbf'）


Database altered.


SQL> alter database open;----->正常启动


Database altered.






#但是数据文件已经恢复不过来了