Beyond Solutions – Blog

ORA-19809: limit exceeded for recovery files

Stamattina Oracle mi da il buon giorno con:

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’

L’errore è generato dalla mancanza di spazio riservato al flash recovery.

Per risolvere il problema bisogna incrementare il valore di

db_recovery_file_dest_size

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

Solution: Backup oracle flash recovery area

(2 votes, average: 5,00 out of 5)

Tags: Oracle

This entry was posted on mercoledì, giugno 21st, 2006 at 21:32and is filed under Oracle, Oracle DBA. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

3 Responses to “ORA-19809: limit exceeded for recovery files”

• mmpdba Says:
  maggio 23rd, 2007 at 18:07

  solved my problem…
  Thanks.
• kritdeo Says:
  aprile 18th, 2008 at 11:11

  hi, i was having another problem ‘Archiver error. Connect internal only, until freed, also……….when tried this it really worked for both these errors…….good one
• kalvari Says:
  maggio 2nd, 2009 at 03:03

  thanx.. solved my problem..

Leave a Reply