1Z0-062 · Question #52
You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? (Choose two.)
The correct answer is A. backup pieces D. control file autobackups. The flash recovery area (Fast Recovery Area) stores RMAN-managed recovery files such as backup pieces and control file autobackups, but not trace files or standalone parameter file copies.
Question
You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? (Choose two.)
Options
- Abackup pieces
- Bcopies of all the parameter files
- Ctrace file generated using BACKUP CONTROLFILE TO TRACE
- Dcontrol file autobackups
How the community answered
(45 responses)- A87% (39)
- B4% (2)
- C9% (4)
Why each option
The flash recovery area (Fast Recovery Area) stores RMAN-managed recovery files such as backup pieces and control file autobackups, but not trace files or standalone parameter file copies.
Backup pieces are a primary file type managed within the flash recovery area; RMAN automatically tracks their retention and deletes obsolete backups according to the configured recovery window or redundancy policy.
The flash recovery area does not store standalone copies of all parameter files; only the SPFILE is captured indirectly within a control file autobackup, and init.ora files are not managed there.
The trace file generated by BACKUP CONTROLFILE TO TRACE is a text script written to the ADR diagnostic trace directory, not to the flash recovery area.
Control file autobackups are placed in the flash recovery area when DB_RECOVERY_FILE_DEST is set, allowing Oracle to recover the control file and SPFILE even after a complete control file loss.
Concept tested: Flash Recovery Area managed file types
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/configuring-db-recovery-area.html
Topics
Community Discussion
No community discussion yet for this question.