Database Upgrade Failed with Error "ORA-19809: limit exceeded for recovery files"
(Doc ID 2114054.1)
Last updated on OCTOBER 25, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |