oracleÀïtablespace offlineºÍdatafile offlineµÄÇø±ð

ÍøÉÏËÑÁ˼¸Æª¹ØÓÚtablespace offline ºÍ datafile offlineÇø±ðµÄÎÄÕ£¬Ð¡×ܽáÁËһϣ¬¼ÇÏÂÀ´£¬·½±ãÒÔºóѧϰ¡£
==================================================================================
There is a big difference between:
Taking the tablespace offline and Taking the datafiles offline
ALTER TABLESPACE ... OFFLINE
Does a checkpoint on the datafiles
Takes the datafiles offline
(´ÓEMÖпÉÒÔ¿´µ½tablespace offlineÓм¸ÖÖÑ¡Ïî¿É¹©Ñ¡Ôñnormal, temporary,immediate, for recovery,¶øÔÚdatafileÖÐÔòûÓÐÕâЩѡÏî)
SQL>select dbms_flashback.get_system_change_number from dual;
GET_SYSTEM_CHANGE_NUMBER
------------------------
27259186261
SQL>alter tablespace block offline;
±í¿Õ¼äÒѸü¸Ä
SQL>select file#,name,checkpoint_change# from v$datafile;
FILE# NAME CHECKPOINT_CHANGE#
......
13 F:\ORACLE\ORADATA\TEST\RMAN.DBF 27259134244
14 F:\ORACLE\ORADATA\TEST\MAGGIE_DATA1.DBF 27207207995
15 F:\ORACLE\ORADATA\TEST\BLOCK01.DBF 27259186316
SQL>select dbms_flashback.get_system_change_number from dual;
GET_SYSTEM_CHANGE_NUMBER
------------------------
27259186335
SQL>alter tablespace block online;
±í¿Õ¼äÒѸü¸Ä
SQL>select file#,name,checkpoint_change# from v$datafile;
FILE# NAME CHECKPOINT_CHANGE#
......
13 F:\ORACLE\ORADATA\TEST\RMAN.DBF 27259134244
14 F:\ORACLE\ORADATA\TEST\MAGGIE_DATA1.DBF 27207207995
15 F:\ORACLE\ORADATA\TEST\BLOCK01.DBF 27259186345
SQL>select dbms_flashback.get_system_change_number from dual;
GET_SYSTEM_CHANGE_NUMBER
------------------------
27259186378

ALTER DATABASE DATAFILE ... OFFLINE
Does not perform. a checkpoint,
So that if the database is open, you may need to perform. media recovery when bringing it online.
SQL>select file#,name,checkpoint_change# from v$datafile;
FILE# NAME CHECKPOINT_CHANGE#
......
13 F:\ORACLE\ORADATA\TEST\RMAN.DBF27259134244
14 F:\ORACLE\ORADATA\TEST\MAGGIE_DATA1.DBF27207207995
15 F:\ORACLE\ORADATA\TEST\BLOCK01.DBF 27259134244
SQL>select dbms_flashback.get_