flash_recovery_area空间不足报错

现象

…
2235_g28w3d16_.bkp tag=TAG20181227T142235 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 12/27/2018 14:25:46
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 4294967296 limit

基本原因

db_recovery_file_dest有size 2G限制，如果用户没有设置过，应该是归档的文件超过了这个大小，导致归档失败了。
查看：

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/app/oracle/archive_log
Oldest online log sequence     255
Next log sequence to archive   257
Current log sequence           257
SQL> show parameter db_recovery_file_dest_size

NAME                                 TYPE        VALUE
--<