rman备份报RMAN-00571、RMAN-00569、RMAN-03009

rman备份时报错信息:
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/03/2012 10:35:17
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 2147483648 limit
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/03/2012 10:35:27
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 2147483648 limit
分析原因:
问题是在db_recovery_file_dest_size 备份时没有足够的空间造成的

解决办法:
1:清理过期失效的备份,
2:增加recovery_file_dest_size参数值即可;

SQL> show parameter db_recover
NAME TYPE VALUE


db_recovery_file_dest string /oracle/flash_recovery_area
db_recovery_file_dest_size big integer 2G
SQL> alter system set db_recovery_file_dest_size=4G scope=spfile;
System altered.
重启数据库

http://blog.itpub.net/14661773/viewspace-734453/

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值