ORA-19809/ORA-19809: limit exceeded for recovery files troubleshooting

ORA-19809/ORA-19809: limit exceeded for recovery files problem processing today encountered this problem, alert Log error information is as follows: in fact, the problem is very simple, put the archive fra space is full, as a result, the archive fails, and oracle suspends. Note that db_recovery_file_dest is only a logical limitation. The fra directory may have space left, but oracle will not be used. Pay more attention to fra usage. You can use v $ flash_recovery_area_usage to view fra usage. Solution:

Rman> crosscheck archivelog all; rman> delete expired archivelog all; alert. log: **************************************** * ******************************* Errors in file d: \ app \ administrator \ diag \ rdbms \ orcl \ trace \ orcl_arc1_7088.trc: ORA-19809: limit exceeded for recovery filesORA-19804: cannot reclaim 13112320 bytes disk space from 4102029312 limitARC1: error 19809 Creating archive log file to 'd: \ APP \ ADMINISTRATOR \ FLASH_RECOVERY_AREA \ ORCL \ ARCHIVELOG \ 2013_09_12 \ O1_MF_1_1750 _ % U_.ARC 'errors in file d: \ app \ administrator \ diag \ rdbms \ orcl \ trace \ ORA-19815: warning db_recovery_file_dest_size byte (4102029312 bytes in total) is 100.00%, and 0 bytes are available. **************************************** * ****************************** You have following choices to free up space from recovery area: 1. consider changing rman retention policy. if you are using Data Guard, then consider changing rman archivelog deletion POLICY.2. Back up files to tertiary device such as tape using rman backup recovery area command.3. Add disk space and increase limit parameter to reflect the new space.4. Delete temporary files using RMAN DELETE command. if an operating system command was used to delete files, then use rman crosscheck and delete expired commands. **************************************** * ******************************* Errors in file d: \ app \ administrator \ diag \ rdbms \ orcl \ trace \ orcl_ora_7072.trc: ORA-19809: exceeds the limit on the number of recovery files ORA-19804: unable to reclaim 13112320 bytes disk space (from 4102029312 limit) ARCH: Error 19809 Creating archive log file to 'd: \ APP \ ADMINISTRATOR \ FLASH_RECOVERY_AREA \ ORCL \ ARCHIVELOG \ 2013_09_12 \ O1_MF_1_1750 _ % U_.ARC 'Errors in file D: \ app \ administrator \ diag \ rdbms \ orcl \ trace \ orcl_ora_7072.trc: ORA-16038: Log 1 sequence #1750 unable to archive ORA-19809: ORA-00312 beyond the limit on the number of recovery files: online log 1 thread 1: 'd: \ APP \ ADMINISTRATOR \ ORADATA \ ORCL \ REDO01.LOG 'user (ospid: 7072 ): terminating the instance due to error 16038Thu Sep 12 10:43:03 2013 Instance terminated by USER, pid = 7072