Problem

If you get the following error and the database can not be opened:

ORA-16038: log 2 sequence# 27216 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: '/opt/oracle/product/10.1.2/ocs/oradata/OCSDB/onlinelog/o1_mf_2_2qdyzv3q_.log'
ORA-00312: online log 2 thread 1: '/opt/oracle/product/10.1.2/ocs/infra/flash_recovery_area/OCSDB/onlinelog/o1_mf_2_2qdyzvcd_.log'

Solution

Increase the side of the db_recovery_file_dest_size.

Log into the database as sysdba

sqlplus /nolog
SQL> connect / as sysdba
SQL> show parameter db_recovery_file_dest_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size           big integer 20G
SQL> alter system set db_recovery_file_dest_size = 25G scope=both;

System altered.

SQL>

Restart the database.