今天读到表空间管理章节，感觉表空间和数据文件的联机、脱机，将来势必会用到，这里不妨先好好学习一下：
表空间如果被脱机之后，之上的数据再访问是会返回错误信息的。表空间的ONLINE OFFLINE都会被SYSTEM表空间的数据字典做记录，一个表空间只能联机到创建她的数据库。
脱机的方式：
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.
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.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26936900/viewspace-749315/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
2012-11-13
下一篇：
遇到了事故，学到点关于重建控制文件的东西
请登录后发表评论
登录
全部评论
