You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA. Which two files are…

Question

Options

• Auser-managed backups of data files and control files
• Bflashback logs
• CRMAN backups that are obsolete
• Darchived redo log files that have multiple copies in a different archive location

• A
  4% (2)
• B
  94% (44)
• D
  2% (1)

Explanation

Oracle's FRA automatic space management deletes flashback logs (B) - trimming them when they exceed DB_FLASHBACK_RETENTION_TARGET - and obsolete RMAN backups (C) - removing backup pieces that fall outside the configured retention policy - because both are fully tracked and managed by Oracle. User-managed backups (A) are excluded because they were created outside of RMAN and Oracle has no catalog entries for them, so it cannot safely determine whether deleting them would compromise recovery. Archived redo logs with copies in another archive destination (D) are also not automatically removed; having a duplicate log copy via LOG_ARCHIVE_DEST is not the same as having a proper RMAN backup - Oracle only auto-deletes archived logs that have been backed up at least the required number of times per the retention policy, not merely duplicated to another location.

Memory tip: Think "FRA auto-cleans what RMAN controls." Flashback logs and RMAN backups are entirely under Oracle/RMAN's management umbrella, so Oracle can safely expire them. User-managed backups and raw archive copies live outside that umbrella - Oracle won't touch what it didn't track.

No community discussion yet for this question.