- How to Clean Fast Recovery Area by RMAN (1/8) - Delete Expired Archivelog.
- How to Clean Fast Recovery Area by RMAN (2/8) - Delete Expired Backup or Copy.
- How to Clean Fast Recovery Area by RMAN (3/8) - Delete Obsolete by Configuring More Restrictive Policies.
- How to Clean Fast Recovery Area by RMAN (4/8) - Delete Specific Archivelog.
- How to Clean Fast Recovery Area by RMAN (5/8) - Delete Specific Backup or Copy.
- How to Clean Fast Recovery Area by RMAN (6/8) - Delete All Archivelog.
- How to Clean Fast Recovery Area by RMAN (7/8) - Delete All Backup or Copy.
- How to Clean Fast Recovery Area by RMAN (8/8) - Increase the Space of FRA.
If you hit ORA-19809, don't be rush to delete files from the fulled FRA on OS-level, because RMAN doesn't know a thing about the deletion and ORA-19809 will still be there. The best tool to clean FRA is RMAN. For more details, please refer to the following articles.