【tablespace】表空间脱机的3种模式

NORMAL
Specify NORMAL to flush all blocks in all datafiles in the tablespace out of the SGA. You need not perform. media recovery on this tablespace before bringing it back online. This is the default.

TEMPORARY
If you specify TEMPORARY, then Oracle performs a checkpoint for all online datafiles in the tablespace but does not ensure that all files can be written. Any offline files may require media recovery before you bring the tablespace back online.

IMMEDIATE
If you specify IMMEDIATE, then Oracle does not ensure that tablespace files are available and does not perform. a checkpoint. You must perform. media recovery on the tablespace before bringing it back online.

normal 为表空间所有文件做checkpoint，操作时表空间的所有文件必须处于在线状态，online时不需要恢复

temporary 为表空间的所有在线文件做checkpoint，操作时已处于offline状态的文件不做checkpoint，online时需要恢复

immediate 不为表空间的任何文件做checkpoint，online时需要恢复

ballontt

2012.11.29

---The End---

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27425054/viewspace-750230/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27425054/viewspace-750230/