Oracle DBA Tips and Techniques

By Arjun Raja

ORA-19809: limit exceeded for recovery files

Posted by Arjun Raja on August 24, 2009

ALERT LOG ERROR  – ORA-19809

If the archivelog desintation as suggested by the parameter db_recovery_file_dest has used all the capacity as indicated in the db_recovery_file_dest_size parameter , then Oracle will not archive the next log until space is added or freed up.

The following error will appear in the alert log if you try to shutdown a database or switch a log file –

ORACLE Instance flash – Archival Error
ORA-16038: log 1 sequence# 43 cannot be archived
ORA-19809: limit exceeded for recovery files

To overcome this error after you have issued the Shutdown Immediate command –

1.  Shutdown abort;

2.  Startup mount;

3.

SQL>

set lines 100

col name format a60

select  name,  (space_limit/1048576),(space_used/1048576)from  v$recovery_file_dest;

NAME                                                         (SPACE_LIMIT/1048576)
———————————————————— ———————
(SPACE_USED/1048576)
——————–
/u02/oradata/flash_recovery_area                                              2048
            2184.979

 SQL> alter system set db_recovery_file_dest_size=4096m scope=both;

SQL> alter database open;

Database altered.

SQL>

Now shutdown immediate;

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

Advertisements

One Response to “ORA-19809: limit exceeded for recovery files”

  1. You really make it seem so easy with your presentation but I find this matter to be really something which I think I would never understand. It seems too complex and very broad for me. I’m looking forward for your next post, I will try to get the hang of it!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: