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

You must design an Oracle Data Guard configuration for an OLTP database that meets these permanent requirements:
1. Data loss is not permitted.
2. Read-only applications should not connect to the primary database instance.
Additionally, there are these requirements, only one of which is ever done at any one time:
1. It should be possible to apply designated patches with a minimum amount of downtime.
2. Upgrading to a new database release should be performed with the least possible amount of downtime.
3. New application software releases should be tested against an exact and up-to-date replica of the primary database.
Which configuration meets these requirements with the fewest databases?

Answer options

• A. a primary database with three physical standby databases
• B. a primary database with one logical and two physical standby databases
• C. a primary database with one logical standby database
• D. a primary database with one logical and one physical standby database
• E. a primary database with two physical standby databases
• F. a primary database with one physical standby database

Correct answer: D

Explanation

The correct answer is D, as it allows for a logical standby database that can be used for testing new application software releases while maintaining a physical standby for data protection. The other options either introduce unnecessary databases or do not provide the required capabilities for testing and minimal downtime during patching or upgrades.