Oracle10g释放flash_recovery_area

ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.
*************************************************************
You have the following choices to free up space from
flash recovery area:
1. Consider changing your RMAN retention policy.
If you are using dataguard, then consider changing your
RMAN archivelog deletion policy.
2. Backup files to tertiary device such as tape using the
RMAN command BACKUP RECOVERY AREA.
3. Add disk space and increase the db_recovery_file_dest_size
parameter to reflect the new space.
4. Delete unncessary files using the RMAN DELETE command.
If an OS command was used to delete files, then use
RMAN CROSSCHECK and DELETE EXPIRED commands.
*************************************************************

这时候实际上flash_recovery_area已经手工释放空间，甚至切换到一个全新的磁盘，仍然无法解决。

连接数据库查询： 发现仍然记录了227个文件，USED空间并未释放。

使用rman登录数据库进行crosscheck： 此时空间得以释放: Oracle指出，我们可以通过执行以下命令: 将闪回区的内容备份到第三方介质，也同样可以解决这个问题。
是以为记。

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/18921899/viewspace-1017447/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/18921899/viewspace-1017447/