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
Explanation:
Configuring the Flash Recovery Area
Flash recovery area:
Strongly recommended for simplified backup storage management
Space on disk (separate from working database files)
Location specified by the DB_RECOVERY_FILE_DEST parameter
Size specified by DB_RECOVERY_FILE_DEST parameter
Large enough for backups, archived logs, flashback logs, mirrored control files, and mirrored
redo logs
Automatically managed according to your retention policy
Configuring the flash recovery area means determining location, size, and retention policy.
Configuring the Flash Recovery Area
The flash recovery area is a space that is set aside on the disk to contain archived logs, backups,
flashback logs, mirrored control files, and mirrored redo logs. A flash recovery area simplifies
backup storage management and is strongly recommended. You should place the flash recovery
area on a disk that is separate from die working set of database files. Otherwise, the disk becomes
a single point of failure for your database.
The amount of disk space to allocate for the flash recovery area depends on the size and activity
levels of your database. As a general rule, the larger the flash recovery area, the more useful it is.
Ideally, the flash recovery area should be large enough for copies of your data and control files
and for flashback, online redo, and archived logs needed to recover the database with the
backups kept based on the retention policy. (In short, the flash recovery area should be at least
twice the size of the database so that it can hold one backup and several archived logs.)
Space management in the flash recovery area is governed by a backup retention policy. A
retention policy determines when files are obsolete, winch means that they are no longer needed
to meet your data recovery objectives. The Oracle database automatically manages this storage
by deleting files that are no longer needed.