Database Upgrade Failed with Error "ORA-19809: limit exceeded for recovery files" (Doc ID 2114054.1)

Last updated on MARCH 14, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Upgrade failed with error "ORA-19809: limit exceeded for recovery files" during the post upgrade steps.

From alert.log

system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Wed Jul 29 16:48:43 2015
Errors in file D:\ORACLE_12_1_0_2\diag\rdbms\testdb\testdb\trace\testdb_arc2_5912.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 46050304 bytes disk space from 4385144832 limit
ARC2: Error 19809 Creating archive log file to 'D:\ORACLE_11204\FAST_RECOVERY_AREA\TESTDB\ARCHIVELOG\2015_07_29\O1_MF_1_111_%U_.ARC'
Wed Jul 29 16:48:43 2015
Errors in file D:\ORACLE_12_1_0_2\diag\rdbms\testdb\testdb\trace\testdb_arc3_4580.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 4385144832 bytes is 100.00% used, and has 0 remaining bytes available.
Wed Jul 29 16:48:43 2015
************************************************************************
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 db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Wed Jul 29 16:48:43 2015
Errors in file D:\ORACLE_12_1_0_2\diag\rdbms\testdb\testdb\trace\testdb_arc3_4580.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 46050304 bytes disk space from 4385144832 limit
ARC3: Error 19809 Creating archive log file to 'D:\ORACLE_11204\FAST_RECOVERY_AREA\TESTDB\ARCHIVELOG\2015_07_29\O1_MF_1_111_%U_.ARC'
Wed Jul 29 16:48:43 2015
Errors in file D:\ORACLE_12_1_0_2\diag\rdbms\testdb\testdb\trace\testdb_arc0_5392.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 4385144832 bytes is 100.00% used, and has 0 remaining bytes available.
Wed Jul 29 16:48:43 2015

SERVER COMPONENT id=ACTIONS_END: timestamp=2015-07-29 16:40:58
SERVER COMPONENT id=UPGRD_END: timestamp=2015-07-29 16:40:58

 

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