ORA-19809: limit exceeded for recovery files

Oracle, Oracle DBA

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

3 pensieri su “ORA-19809: limit exceeded for recovery files”

  2. 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

Rispondi