nerdexam
Oracle

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.

New Features for Database Infrastructure and Architecture

Question

Examine these parameters settings:

What is true about the control file?

Exhibit

1Z0-060 question #222 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)
  • A
    93% (40)
  • B
    2% (1)
  • D
    5% (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.

AThe control file is multiplexed in the locations specified by DB_CREATE_ONLINE_LOG_DEST_1Correct

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.

BOnly a single control file exists in the location specified by DB_CREATE_FILE_DEST.

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.

DOnly a single control file exists in the location specified by DB_RECOVERY_FILE_DEST.

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.

EThe control file is multiplexed in the locations specified by DB_CREATE_FILE_DEST and

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

#control file multiplexing#OMF#DB_CREATE_FILE_DEST#initialization parameters

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice