Rman备份由于空间不足导至的错误

报错信息：

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 52428800 bytes disk space from 2147483648 limit

原因：flash_recovery_area空间不足

检查flash_recovery_area使用情况
SQL>  select file_type, percent_space_used as used,percent_space_reclaimable as reclaimable,number_of_files as "number" from v$flash_recovery_area_usage;

检查db_recovery_file_dest_size参数
SQL> show parameter db_recovery_file_dest_size

将参数db_recovery_file_dest_size增大为10G
SQL> alter system set db_recovery_file_dest_size=10G scope=both;
System altered.


再次备份，成功
RMAN>  backup database plus archivelog delete input;