ORA-19809 ORA-19804 when clearning logfile

執行 clear logfile group，出現 ORA-19809 ORA-19804 錯誤

SQL> alter database clear logfile group 11;
alter database clear logfile group 11
*
ERROR at line 1:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 210763776 bytes disk space from 10737418240 bytes
limit

確認 ORA-19804 訊息內容

[oracle@cbs-cbrdb1 ~]$ oerr ora 19804
19804, 00000, "cannot reclaim %s bytes disk space from %s bytes 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.

檢查 db_recovery_file_dest_size 大小，並增加空間大小

SQL> show parameter db_recovery

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest		     string	 +DATADG
db_recovery_file_dest_size	     big integer 10G

SQL> alter system set db_recovery_file_dest_size=20G scope=both;

重新執行 clear logfile group

SQL> alter database clear logfile group 11;

Database altered.