ORA-19809: limit exceeded for recovery files

Unable to startup the database due to ORA-19809: limit exceeded for recovery files

Problem

The database will not mount when started

SQL> startup
ORACLE instance started.

Total System Global Area  608174080 bytes
Fixed Size                  1263200 bytes
Variable Size             406849952 bytes
Database Buffers          192937984 bytes
Redo Buffers                7122944 bytes
Database mounted.
ORA-16038: log 3 sequence# 1933 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1:
‘/home/oracle/oracle/product/10.2.0/oradata/mca10gR2/redo03.log’

Solution

Increase the size of the DB_RECOVERY_FILE_DEST_SIZE

SQL> show parameter DB_RECOVERY_FILE_DEST_SIZE

NAME                                 TYPE        VALUE
———————————— ———– ——————————
db_recovery_file_dest_size           big integer 8G
SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE = 10G;

System altered.

SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  608174080 bytes
Fixed Size                  1263200 bytes
Variable Size             411044256 bytes
Database Buffers          188743680 bytes
Redo Buffers                7122944 bytes
Database mounted.
Database opened.
SQL>

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>