SQL> alter database datafile '/u01/oracle/product/102/dbs/MISSING00007' online;
alter database datafile '/u01/oracle/product/102/dbs/MISSING00007' online
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01111: name for data file 7 is unknown - rename to correct file
ORA-01110: data file 7: '/u01/oracle/product/102/dbs/MISSING00007'
再查询offline状态的数据文件,查询不到
SQL> select name,status from v$datafile where status='OFFLINE';
no rows selected
在系统目录下查询也没有发现数据文件
[oracle@Trac3-vm-szzb rman_backup]$ cd /u01/oracle/product/102/dbs/
[oracle@Trac3-vm-szzb dbs]$ ls
hc_vankeT.dat initdw.ora init.ora lkVANKET orapwvankeT snapcf_vankeT.f spfilevankeT.ora