Foreign Archive Logs (11g)
Jump to navigation
Jump to search
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;