Monday, May 20, 2013

ORA-19809: limit exceeded for recovery files

I often happen when the The Fast Recovery Area (FRA) is full with old archive log file  and so need to be emptied.
   Let's get in the RMAN
  1. rman> connect target /
  2. rman> crosscheck archivelog ALL;
  3. rman> list expired archivelog ALL;
  4. rman>DELETE expired archivelog ALL;
  5. rman>delete archivelog all completed before 'SYSDATE-1';
  6. rman>exit;

You may also like to adjust the size of the FRA:

 SQL> alter system set db_recovery_file_dest_size=10G;
 output:  system altered

You will be able to archive
SQL> archive log all;
output: 2 logs archived.

No comments:

Post a Comment