ALTER TABLESPACE users OFFLINE NORMAL;----后面加NORMAL和不加NORMAL,有和区别?
解决方案 »
- Oracle Developer Suite 10g 和oracle application 这两个区别
- 请大虾们推荐一下oralce c++编程的好资料
- Oracle不能通过localhost或者127.0.0.1访问数据库
- oracle启动报错.ORA-01033: ORACLE initialization or shutdown in progress
- 左连接问题
- Oracle 9i 只能用as sysdba 登陆
- 普通PC机器可否让ORACLE数据库带得起25个用户的连接?
- 执行存储过程问题
- 很菜的问题!请问这句话:SELECT TO_DATE('1999-8-9 14:18:35' ,'yyyy-mm-dd') FROM DUAL;错在哪儿?解决马上给分
- 搞分寻找ASP+oracle高手!如何实现客户端的图片存到远程数据库oracle中的BLOB字段中?
- 导出数据的时候query的参数如何处理?
- 请问怎么在archive mode下备份?
NORMAL
A tablespace can be taken offline normally if no error conditions exist for any of the datafiles of the tablespace. No datafile in the tablespace can be currently offline as the result of a write error. When OFFLINE NORMAL is specified, Oracle takes a checkpoint for all datafiles of the tablespace as it takes them offline. NORMAL is the default.
TEMPORARY
A tablespace can be taken offline temporarily, even if there are error conditions for one or more files of the tablespace. When OFFLINE TEMPORARY is specified, Oracle takes offline the datafiles that are not already offline, checkpointing them as it does so. If no files are offline, but you use the temporary option, media recovery is not required to bring the tablespace back online. However, if one or more files of the tablespace are offline because of write errors, and you take the tablespace offline temporarily, the tablespace requires recovery before you can bring it back online.
IMMEDIATE
A tablespace can be taken offline immediately, without Oracle taking a checkpoint on any of the datafiles. When you specify OFFLINE IMMEDIATE, media recovery for the tablespace is required before the tablespace can be brought online. You cannot take a tablespace offline immediately if the database is running in NOARCHIVELOG mode.
FOR RECOVER
Takes the database tablespaces in the recovery set offline for tablespace point-in-time recovery. For additional information, see Oracle9i User-Managed Backup and Recovery Guide.
online时,不需要media recovery,同时tablespace内所有的数据文件上再次触发checkpoint。 checkpoint_change#增加。
2、offline temporary:
If no files are offline, but you use the temporary option, media recovery is not required to bring the tablespace back online.
offline temporary只对那些online的数据文件进行checkpoint,而且在将tablespace online 的时候,那些进行过checkpoint的数据文件将不需要media recovery
3、offline immediate,tablespace内所有的数据文件上不触发checkpoint。 checkpoint_change#不变。
将tablespace online 时需要media recovery