文档:
1 OFFLINE
Specify OFFLINE to take the datafile offline. If the database is open,
you must perform. media recovery on the datafile before bringing it back online,
because a checkpoint is not performed on the datafile before it is taken offline
2 Using OFFLINE DROP intercated that u were intending to drop the tablespace.
There is no way for u remove one of datafiles belong to the same tablespace.
please exp all contents within the problem tablespace, and drop it, create a new one,
and reimport. If recreation of tablespace can not be done currently,
and u can not endure using one of its datafile, you can shrink its size to less than 5 blocks
after making sure there is no data in the specific datafile.
and leaving recreation of tablespace to a proper time.
if you do not like the datafile's name, use rename, if the datafile has wrong size,
use resize, if the datafile is corrupted, use recover.
3 在归档模式下:这两种方式没有区别
在非归档模式下:如果想让数据文件(注意不是表空间)脱机一般只能使用alter database datafile offline drop。
只有在一种情况下可以使用alter database datafile offline,那就是该表空间正处于read only状态。
(其他情况使用alter database datafile offline都会报如下错误:ORA-01145: 除非启用了介质恢复,否则不允许紧急脱机)
4 非归档模式下,联机日志并不归档。
数据库作recover时,只能利用归档日志和 current redo log联机日志。实际上所有的联机日志都是可以用的
,offline drop命令相当于把一个数据文件至于离线状态,并且需要恢复或再也不使用此数据文件了。
所在,在OS级别并不是删除数据文件的意思。但是要在非档模式下恢复此数据文件的前提是,
联机日志中自数据文件创建以来的所有联机日志都没有被覆盖。
数据库处于非归档模式,只要数据文件创建以来的联机日志还没有被覆盖,数据文件就可以恢复出来
5 是否recover?(数据文件offline 不触发检查点,tablespace 的不需要 checkpoint,datafile的需要 no checkpoint)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13750068/viewspace-701486/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13750068/viewspace-701486/