ORA-19809: limit exceeded for recovery files

Today Oracle say me ‘have a good day’ with:

ERROR at line 1:
ORA-16038: log 1 sequence# 230 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: ‘/oradata/…/redo01.log’

Cause:

We register all the information about what we place in the flash recovery
area in the rman repository/controlfile. If we determine that there is not
sufficient space in the recovery file destination, as set by dest_size then
we will fail.

Fix:

Increase the parameter db_recovery_file_dest_size.

Es.: SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=10G SCOPE=BOTH;
Reference: terrencemiao

Solution: Backup oracle flash recovery area

Leave a Reply