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.)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 policyConfiguring the flash recovery area means determining location, size, and retention policy.Configuring the Flash Recovery AreaThe 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.
Question:
Which two files are removed automatically if the space is required in the FRA as per the retention policy?
Options:
Flashback log files
Backups that have become obsolete
User managed backups of the data files and control files
Archived redo log files that have multiple copies in a different archive location and not backed up
Correct Answer
The Correct Answer for this Question is
Flashback log files
Backups that have become obsolete
