本文详细介绍了在不同模式下将表空间设置为离线状态的方法：正常模式确保所有数据文件都进行了检查点操作；临时模式只对在线数据文件进行检查点但不能保证所有文件都已写入；立即模式不执行检查点且数据文件可用性不受保障。
Take Offline
Normal: Takes the tablespace offline in normal mode.
A checkpoint is performed for all datafiles in the tablespace (all of these datafiles must be available). You need not perform media recovery on this tablespace before placing it back online. You must use this option if the database is in NOARCHIVELOG mode.
Temporary: Takes the tablespace offline in temporary mode.
A checkpoint is performed 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 place the tablespace back online.
Immediate: Takes the tablespace offline in immediate mode.
Oracle does not ensure that the datafiles are available, and no checkpoint is performed. You must perform media recovery on the tablespace before placing it back online.
本文转自
http://www.gc.maricopa.edu/business/oracle/docs/Oracle80Docs/doc/oem.804/a57694/ch_store.htm
Normal: Takes the tablespace offline in normal mode.
A checkpoint is performed for all datafiles in the tablespace (all of these datafiles must be available). You need not perform media recovery on this tablespace before placing it back online. You must use this option if the database is in NOARCHIVELOG mode.
Temporary: Takes the tablespace offline in temporary mode.
A checkpoint is performed 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 place the tablespace back online.
Immediate: Takes the tablespace offline in immediate mode.
Oracle does not ensure that the datafiles are available, and no checkpoint is performed. You must perform media recovery on the tablespace before placing it back online.
本文转自
http://www.gc.maricopa.edu/business/oracle/docs/Oracle80Docs/doc/oem.804/a57694/ch_store.htm
扫一扫
891
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
