Which two files are removed automatically if the space is required in the FRA as per the retention policy?

You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.
Which two files are removed automatically if the space is required in the FRA as per the retention policy? (Choose two.)

You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.
Which two files are removed automatically if the space is required in the FRA as per the retention policy? (Choose two.)

A.
Flashback log files

B.
Backups that have become obsolete

C.
User managed backups of the data files and control files

D.
Archived redo log files that have multiple copies in a different archive location and not backed up



Leave a Reply 1

Your email address will not be published. Required fields are marked *


mcitpx4

mcitpx4

The files in the flash recovery area can be classified as permanent or transient. The only permanent files are multiplexed copies of the current control file and online redo logs. These cannot be deleted without causing the instance to fail. All other files are transient, because Oracle will generally eventually delete these files, at some point after they become obsolete under the retention policy or have been backed up to tape. Transient files include archived redo logs, datafile copies, control file copies, control file autobackups, and backup pieces.
Flashback logs, which are also considered transient files and must be stored in the flash recovery area. However, unlike other transient files, flashback logs cannot be backed up to other media. They are automatically deleted as space is needed for other files in the flash recovery area.