Using Fast Recovery Area to let Oracle automatically manage the backup/flashback/recovery related files is very useful, but avoiding problems related with FRA free space shortage requires careful planning. There are several factors that have to be taken into account, apart from the most obvious like DB_RECOVERY_FILE_DEST_SIZE parameter, there are some additional ones depending on the type of files stored. For example DB_FLASHBACK_RETENTION_TARGET (and _MINIMUM_DB_FLASHBACK_RETENTION) affecting flashback logs or archived logs deletion policy which is also taken into account while reclaimable files purging is done.
Skip to content
Change is the only constant... 