ORACLE RMAN

ORA-19809: limit exceeded for recovery files tips

The solution to the ORA-19809 error is to increase the value of your db_recovery_file_dest_size parameter and bounce the instance:

SQL> alter database open;

alter database open
*

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: '/opt/oracle/db/home/data/imapdb/redo01.log'

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=2048576000 SCOPE=BOTH;

SQL> shutdown abort

SQL> startup