1Z0-062 · Question #186
Which three file types are stored in the Fast Recovery Area by default in a traditional nonOMF file system?
The correct answer is C. multiplexed copies of the current control file D. archived log files F. Flashback logs. The Fast Recovery Area automatically stores certain file types by default to support backup and recovery operations. In a non-OMF file system, only multiplexed control file copies, archived logs, and flashback logs are placed there by default.
Question
Which three file types are stored in the Fast Recovery Area by default in a traditional nonOMF file system?
Options
- Aonline redo log files
- Bparameter file
- Cmultiplexed copies of the current control file
- Darchived log files
- EFlashback Data Archive files
- FFlashback logs
How the community answered
(32 responses)- A3% (1)
- B6% (2)
- C91% (29)
Why each option
The Fast Recovery Area automatically stores certain file types by default to support backup and recovery operations. In a non-OMF file system, only multiplexed control file copies, archived logs, and flashback logs are placed there by default.
Online redo log files are stored in the main database area or a location specified by the DBA, not in the Fast Recovery Area by default.
The server parameter file (SPFILE) resides in the Oracle home or a DBA-specified path and is not automatically placed in the FRA.
Oracle automatically creates a multiplexed copy of the current control file in the FRA by default, providing redundancy without manual configuration.
Archived redo log files are written to the FRA by default when the DB_RECOVERY_FILE_DEST parameter is set, making it the primary archival destination.
Flashback Data Archive files are stored in dedicated tablespaces created by the DBA, not in the Fast Recovery Area.
Flashback logs are exclusively stored in the FRA because the FRA is required for the Flashback Database feature to function; they cannot be stored elsewhere.
Concept tested: Fast Recovery Area default file storage types
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/configuring-rman-operating-environment.html
Topics
Community Discussion
No community discussion yet for this question.