oracle 10g flash_recover默认大小为2G,当备份集、归档日志大小超过2G时,数据库就会down掉或连接不上,如果在物理磁盘下手工已经删除过期备份集、归档日志,磁盘空间也足够,但数据库还是无法连接,其实oracle的备份集、归档日志记录信息还是存在,所以还是要在rman下手动清除![@more@]
清除快速恢复区占满空间
使用rman登录数据库
rman >target=sys/password@db
rman >crosscheck archinelog all;
rman> delete expired archivelog all; (删除归档日志)
rman>crosscheck backupset;
rman>delete expired backupset;
rman>crosscheck backupset completed before "trunc(sysdate-16)"; (只检查16天的备份)
rman>delete expired backupset completed before "trunc(sysdate-16)";
Rman> allocate channel for maintenance type disk;(更改备份集默认为磁盘)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/556989/viewspace-903248/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/556989/viewspace-903248/