Note:315098.1,提出了几个方法 You have following choices to free up space from flash recovery area: 1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, then consider changing RMAN ARCHIVELOG DELETION POLICY. 2. Back up files to tertiary device such as tape using RMAN BACKUP RECOVERY AREA command. 3. Add disk space and increase db_recovery_file_dest_size parameter to reflect the new space. 4. Delete unnecessary files using RMAN
To make space reclaimable we have the following options:
1) The space occupied by archivelogs created in the Flash Recovery Area would become reclaimable in 2 circumstances:
A) If the free space becomes less then 15% in the Flash Recovery Area then all the archivelogs in the Flash Recovery Area which are not needed for recovery by the current backups in the FRA will become obsolete and the space occupied will be shown in the SPACE RECLAIMABLE column of V$RECOVERY_FILE_DEST.
B) If the archivelogs have been backed up (either to the Flash Recovery Area itself or to another destination) and the archivelog not deleted. Then the space occupied by that archivelog will be marked as reclaimable.
2) When the Flash Recovery Area is full and there is no space available to create archivelogs in the Flash Recovery Area. We will get the following error in the alert log:
3) To free space in the FRA we could do take a backup of the Flash Recovery Area using the command BACKUP RECOVERY AREA. This command will take the backup of al the files in the FRA to tape only. After this the space occupied by the files in the FRA will be marked as reclaimable.