Search This Blog

Tuesday, September 25, 2007

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.

6 comments:

Anonymous said...

Nice dispatch and this fill someone in on helped me alot in my college assignement. Thank you on your information.

Anonymous said...

THANK YOU DUDE..ITS WORKING FOR ME..

Anonymous said...

Thank you so much boss.
I tried for this since 1 hour.But with your tip I did it in 1 minute

Anonymous said...

Thank you so much......

nasiruiu said...

Thanks for your information .
Most of the blogger user this command "alter system set db_recovery_file_dest_size=30GB;"

but its occurs error,

nasiruiu said...

alter system set db_recovery_file_dest_size=30GB;
Most of the blogger use this commands
but its wrong