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

You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. A Physical Standby Database
3. A Snapshot Standby Database
You must meet these requirements:
1. Primary database availability should not be compromised by the availability of the standby databases.
2. Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on the primary database and on at least one standby database.
Which redo transport mode, and which protection mode should you configure to meet these requirements?

Answer options

• A. SYNC AFFIRM and Maximum Protection
• B. SYNC NOAFFIRM and Maximum Protection
• C. SYNC AFFIRM and Maximum Availability
• D. SYNC NOAFFIRM and Maximum Availability
• E. ASYNC and Maximum Performance

Correct answer: C

Explanation

The correct choice is C, SYNC AFFIRM and Maximum Availability, because it ensures that the primary database does not compromise availability while guaranteeing that transactions are committed only after redo data is written to both the primary and at least one standby database. Options A and B focus on Maximum Protection, which may hinder primary database availability, while D offers SYNC NOAFFIRM, which does not meet the requirement of writing redo to standby before committing. Option E, ASYNC and Maximum Performance, does not provide the necessary commitment guarantees.