Oracle error ORA-19809: limitexceededforrecoveryfiles Solution

Oracle error ldquo; ORA-19809: limitexceededforrecoveryfilesrdquo; Solution

Oracle error ldquo; ORA-19809: limit exceeded for recovery filesrdquo; Solution

When running the archive command, the database reports the following error:

The reason for this error is that the size of the recovery file exceeds the limit. There are two solutions: one is to delete the old file and the other is to expand the space limit.

1. Delete the old file

This method is used to access RMAN and delete part of the archive file (or delete all)

2. Expand the space limit

First find the location of the archive file

The location of the archived log is DB_RECOVERY_FILE_DEST, and the exact path can also be found.

View space usage

Then you can add db_recovery_file_dest_size.

Related reading:

About ORA-01000: maximum open cursors exceeded problem analysis summary

Questions about Oracle cursors (ORA-01000: maximum open cursors exceeded)

Oracle ORA-01000: maximum open cursors exceeded

ORA-01000: maximum open cursors exceeded