Db Hangs Because Archive Logs Get Not Deleted Although Enough Reclaimable Space (Doc ID 434049.1)

Last updated on AUGUST 09, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 16-Apr-2014***
***Checked for relevance on 06-July-2015***

Symptoms

Database hangs during archiving with following error messages in alertfile, although there is enough reclaimable space in the flash recovery area:

Errors in file /oracle/admin/DWHE2/bdump/dwhe2_rvwr_221590.trc:
ORA-19816: WARNING: Files may exist in db_recovery_file_dest that are not known to database.
ORA-38701: Flashback database log 685 seq 5891 thread 2: "+DWHE_FRA"
ORA-17502: ksfdcre:4 Failed to create file +DWHE_FRA
ORA-15041: diskgroup space exhausted
*************************************************************
WARNING: A file of type FLASH BACK may exist in
db_recovery_file_dest that is not known to the database.
Use the RMAN command CATALOG RECOVERY AREA to re-catalog
any such files. This is most likely the result of a crash
during file creation.
*************************************************************

Errors in file /oracle/admin/DWHE2/bdump/dwhe2_arc1_582550.trc:
ORA-19504: failed to create file "+DWHE_FRA"
ORA-17502: ksfdcre:4 Failed to create file +DWHE_FRA
ORA-15041: diskgroup space exhausted
ARC1: Error 19504 Creating archive log file to '+DWHE_FRA'
ARCH: Archival stopped, error occurred. Will continue retrying
Thu May 31 08:09:24 2007
ORACLE Instance DWHE2 - Archival Error
Thu May 31 08:09:24 2007
ORA-16038: log 6 sequence# 2518 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 6 thread 2: '/oracle/oradata/DWHE/redo203.rdo'
ORA-00312: online log 6 thread 2: '/oracle/oradata/DWHE/redo213.rdo'

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms