报错信息:
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;