问题是这样的
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Prod
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
SQL> alter database datafile '+DG1/jane/datafile/jane.dbf' offline drop;
Database altered.
SQL> select NAME,STATUS from v$datafile;
NAME STATUS
------------------------------------------------------------ -------
+DG1/jane/datafile/system.256.727289079 SYSTEM
+DG1/jane/datafile/undotbs1.258.727289081 ONLINE
+DG1/jane/datafile/sysaux.257.727289079 ONLINE
+DG1/jane/datafile/users.259.727289081 ONLINE
+DG1/jane/datafile/jane.dbf RECOVER
我要问的问题是
offline drop这个命令是不是只是把控制文件中的datafile标识成RECOVER状态
这样就能使用
alter database recover datafile '';
进行恢复
SQL> alter database recover datafile '+DG1/jane/datafile/jane.dbf';
Database altered.
SQL> select NAME,STATUS from v$datafile;
NAME STATUS
------------------------------------------------------------ -------
+DG1/jane/datafile/system.256.727289079 SYSTEM
+DG1/jane/datafile/undotbs1.258.727289081 ONLINE
+DG1/jane/datafile/sysaux.257.727289079 ONLINE
+DG1/jane/datafile/users.259.727289081 ONLINE
+DG1/jane/datafile/jane.dbf OFFLINE
有点被offline drop这个字眼所迷惑