QuestionQ14

Oracle Data Guard Overview

Which TWO statements are correct about database parameters for databases in a Data Guard environment?

Choose two
  • A If DB_RECOVERY_FILE_DEST is specified, then LOG_ARCHIVE_DEST_n is not required for local archive logs.
  • B DB_FILE_NAME_CONVERT is only required if the standby database is on the same host as the primary database.
  • C The databases that are part of a Data Guard configuration must have different DB_INIQUE_NAME initialization parameters.
  • D COMPATIBLE must have identical values for primary and standby databases.
  • E LOG_FILE_NAME_CONVERT applies to online redo logs and archived logs.
Explanation

A configured fast recovery area can be used as the default local archive destination when an explicit local LOG_ARCHIVE_DEST_n destination has not been configured. Each database must also have a distinct DB_UNIQUE_NAME, which identifies that database independently of its current primary or standby role. COMPATIBLE is specified with the same value when switchover is expected, rather than being an unconditional requirement for every configuration.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!