Upgrade to Oracle Database 12c — Question 16

You configured the Fast Recovery Area (FRA) for your database, which is in ARCHIVELOG mode.
The default location for the archived log files is the Fast Recovery Area.
There are no guaranteed restore points defined in the database.
Which two file types are removed automatically based on RMAN retention policy settings, if there is pressure for space in the FRA? (Choose two.)

Answer options

• A. obsolete RMAN backups
• B. flashback log files
• C. user-managed backups of control files
• D. expired RMAN backups
• E. archived redo log duplexed to another destination but not yet backed up
• F. user-managed backups of data files

Correct answer: B, D

Explanation

The correct answers are B and D. Flashback log files are automatically removed to free up space when the FRA is under pressure, and expired RMAN backups are also purged as they are no longer needed. The other options, such as obsolete RMAN backups and user-managed backups, do not have the same automatic removal criteria based on RMAN retention policies.