新建一个表空间,一个数据文件 #没有备份
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.
#但是数据文件已经恢复不过来了
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.
#但是数据文件已经恢复不过来了