Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-19809

limit exceeded for recovery files

Cause

The limit for recovery files specified by the DB_RECOVERY_FILE_DEST_SIZE parameter was exceeded.


Action

There are five possible solutions:

  1. Take frequent backup of recovery area using RMAN.
  2. Consider changing RMAN retention policy.
  3. Consider changing RMAN archived log deletion policy.
  4. Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.
  5. Delete files from recovery area using RMAN.