ORACLE RMAN
Submitted by aa.gusti on Tue, 05/11/2013 - 12:17
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