How to clean up the flash recovery area from archive logs.

Hi,

If the flash recovery area is filled up for example by archive logs you can check it using this query:

select * from V$FLASH_RECOVERY_AREA_USAGE;

To clean up FRA from archive logs you can physically delete archive logs from files system where FRA is located then execute RMAN connect to target and catalog if you use the last one and run the following script for cross checking and delete archive log files which we just physically deleted:

crosscheck archivelog all ;
delete expired archivelog all;

Thanks,
Sergey.