Foreign Archive Logs (11g)

A colleague of mine recently noticed in our Fast Recovery Area (aka Flash Recovery Area) that some FOREIGN ARCHIVED LOGS were taking up space. We knew from a recent implementation that these were left-overs from a previous incarnation of our database and we needed to remove them. We achieved this task the following way:

Determined the space being consumed in the FRA

SQL> SELECT * 
       FROM SYS.V_$FLASH_RECOVERY_AREA_USAGE;

Crosschecked the foreign archive logs using rman

RMAN> CROSSCHECK FOREIGN ARCHIVELOG ALL;

Removed the foreign archive logs using rman

RMAN> DELETE EXPIRED FOREIGN ARCHIVELOG ALL;