1Z0-060 · Question #222
Examine these parameters settings: What is true about the control file?
The correct answer is A. The control file is multiplexed in the locations specified by DB_CREATE_ONLINE_LOG_DEST_1. When DB_CREATE_ONLINE_LOG_DEST_n parameters are configured, Oracle OMF uses those destinations for automatic multiplexed control file placement, overriding other storage parameters.
Question
Examine these parameters settings:
What is true about the control file?
Exhibit
Options
- AThe control file is multiplexed in the locations specified by DB_CREATE_ONLINE_LOG_DEST_1
- BOnly a single control file exists in the location specified by DB_CREATE_FILE_DEST.
- DOnly a single control file exists in the location specified by DB_RECOVERY_FILE_DEST.
- EThe control file is multiplexed in the locations specified by DB_CREATE_FILE_DEST and
How the community answered
(43 responses)- A93% (40)
- B2% (1)
- D5% (2)
Why each option
When DB_CREATE_ONLINE_LOG_DEST_n parameters are configured, Oracle OMF uses those destinations for automatic multiplexed control file placement, overriding other storage parameters.
When DB_CREATE_ONLINE_LOG_DEST_1 (and additional numbered destinations) are set, Oracle Managed Files automatically places one copy of the control file in each specified destination, resulting in a multiplexed control file across those locations.
DB_CREATE_ONLINE_LOG_DEST_n parameters take precedence over DB_CREATE_FILE_DEST for control file and online log placement, so a single control file residing only in DB_CREATE_FILE_DEST is not the outcome when the numbered destination parameters are also configured.
DB_RECOVERY_FILE_DEST defines the Fast Recovery Area and is not the primary destination for control files when DB_CREATE_ONLINE_LOG_DEST_1 is explicitly set, because the numbered destination parameters take precedence.
When DB_CREATE_ONLINE_LOG_DEST_1 is set and takes precedence, Oracle does not fall back to multiplexing across both DB_CREATE_FILE_DEST and DB_RECOVERY_FILE_DEST as a combined pair.
Concept tested: Oracle OMF control file multiplexing with DB_CREATE_ONLINE_LOG_DEST
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-control-files.html
Topics
Community Discussion
No community discussion yet for this question.
