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.

How to create a flash recovery area.

Hi,

To create a flash recovery area from scratch the following two commands need to be executed:

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = (Size of FRA for example 10G) SCOPE=BOTH;

and

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = (Path to FRA for example '/u01/flash_recovery_area') SCOPE=BOTH;

That is it.


Thanks,
Sergey.