rman備份時(shí)報(bào)錯(cuò)信息：

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 05/03/2022 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 備份時(shí)沒有足夠的空間造成的

解決辦法：

1：清理過期失效的備份，

2：增加recovery_file_dest_size參數(shù)值即可；

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.

重啟數(shù)據(jù)庫