ORA-19809: limit exceeded for recovery files

When we are trying to connect to database then getting below error message.
Database 10gr1




SQL> conn system/oracle@orcl

ORA-00257: archiver error. Connect internal only, until freed.


Note: When check alert_sid.log file and come to know flash_recovery_area is full.
then increase "db_recovery_file_dest_size" parameter value


SQL> alter system set db_recovery_file_dest_size =6g;

System altered.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16038: log 1 sequence# 20351 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\REDO01.LOG'


Note: After increase "db_recovery_file_dest_size" parameter value getting above error.

So need to check flash_recovery_area V$recovery_file_dest for how much space needed.


NAME SPACE USED
---------------------------------------- ---------- ----------
D:\oracle\product\10.1.0\Flash_recovery 6144 8603


Note: need to increase more 3 gb size in flash_recovery_area.

SQL> alter system set db_recovery_file_dest_size = 10g;

System altered.

SQL> alter database open;

Database altered.