1Z0-062 · Question #339
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…
The correct answer is C. RMAN backups that are obsolete D. flashback logs. When the Fast Recovery Area (FRA) requires additional space, it automatically purges files no longer needed for recovery based on their configured retention policies.
Question
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 removed automatically if space is required in the FRA as per the retention policy? (Choose two.)
Options
- AArchived redo log files that have multiple copies in a different archive location
- Buser-managed backups of data files and control files
- CRMAN backups that are obsolete
- Dflashback logs
How the community answered
(48 responses)- A19% (9)
- B8% (4)
- C73% (35)
Why each option
When the Fast Recovery Area (FRA) requires additional space, it automatically purges files no longer needed for recovery based on their configured retention policies.
While archived redo log files that have multiple copies or are backed up are eventually removed, 'obsolete RMAN backups' (C) and 'flashback logs' (D) are more direct and higher-priority categories for automatic deletion when the FRA needs space according to retention policies.
User-managed backups are not integrated with the RMAN catalog and are therefore not tracked or managed by the Fast Recovery Area for automatic deletion based on database retention policies.
RMAN backups that have been deemed obsolete according to the configured RMAN retention policy are among the primary candidates for automatic deletion by the FRA when space is constrained, as they are no longer necessary for meeting the recovery objectives.
Flashback logs, essential for the Flashback Database feature, are automatically removed from the Fast Recovery Area by the database when their retention target (DB_FLASHBACK_RETENTION_TARGET) is exceeded and more space is urgently needed.
Concept tested: Oracle Fast Recovery Area (FRA) Space Management
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-the-fast-recovery-area.html#GUID-987770E8-518D-4F12-A0FB-5D7E106D44C2
Topics
Community Discussion
No community discussion yet for this question.