【tablespace】表空間離線的3種模式

ballontt發表於2012-11-29
模式
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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章