rman备份失败
ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 1561238528 bytes disk space from 21474836480 limit
查看错误提示
[oracle@oracle11-1 ~]$ oerr ora 19804 19804, 00000, "cannot reclaim %s bytes disk space from %s limit" // *Cause: Oracle cannot reclaim disk space of specified bytes from the // DB_RECOVERY_FILE_DEST_SIZE limit. // *Action: There are five possible solutions: // 1) Take frequent backup of recovery area using RMAN. // 2) Consider changing RMAN retention policy. // 3) Consider changing RMAN archived log deletion policy. // 4) Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE. // 5) Delete files from recovery area using RMAN. [oracle@oracle11-1 ~]$
修改Oracle Flash recovery area,增大到10G
alter system set db_recovery_file_dest_size=10G scope=both;
然后检查
select * from v$recovery_file_dest; show parameter db_recovery_file_dest select * from v$flash_recovery_area_usage;
问题解决。