Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 29

Which three statements are true about Data Guard configurations?

Answer options

• A. All databases in one Data Guard environment must have the same database name.
• B. VALID_FOR is a LOG_ARCHIVE_DEST_N attribute that enables DB role change operations without having to modify LOG_ARCHIVE_DEST_n when performing switchovers or failovers.
• C. For Standard Edition, LOG_ARCHIVE_DUPLEX_DEST is used to configure redo transport, from the primary to the standby database.
• D. When using the Data Guard Broker, an spfile is not required.
• E. Up to 30 physical standby databases may exist within one configuration.
• F. The Oracle recommendation for the number of standby redo log groups per thread is one more than the number of online redo log groups per thread.

Correct answer: A, E, F

Explanation

Statements A, E, and F are correct because all databases in a Data Guard configuration must have the same name, a maximum of 30 physical standby databases can be part of one configuration, and the recommended count of standby redo log groups is indeed one more than the online redo log groups. Options B, C, and D contain specific attributes or configurations that do not apply universally or are incorrect in the context of Data Guard environments.