Offline drop 只會將datafile 進入到需recover 的狀態

筆記from itpub...

 

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

------------------------------------------------------------ -------

+DG/orcl/datafile/system.256.727289079                      SYSTEM

+DG/orcl/datafile/undotbs1.258.727289081                     ONLINE

+DG/orcl/datafile/sysaux.257.727289079                      ONLINE

+DG/orcl/datafile/users.259.727289081                             ONLINE

+DG/orcl/datafile/jane.dbf                                     RECOVER

 

 

offline drop其實不是真正的drop

datafile 只是處於一個recover狀態，只要再recover一下就變成

offline狀態，然後再alter online就可以使用了