Which redo transport mode and protection mode would you configure to meet these requirements?

Prev Question
Next Question

You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. Three Physical Standby Databases
You must meet these requirements:
1. A designated physical standby database should become the primary database automatically whenever the
primary database falls.
2. The chosen protection mode should provide the highest level of protection possible without violating the
other requirement.
Which redo transport mode and protection mode would you configure to meet these requirements?

A.
SYNC NOAFFRIM and Maximum Protection

B.
SYNC NOAFFIRM and Maximum Availability

C.
ASYNC and Maximum Performance

D.
SYNC AFFIRM and Maximum Availability

E.
SYNC AFFIRM and Maximum Protection

Explanation:
The Maximum Availability protection mode provides the highest level of data protection that is possible without
compromising the availability of a primary database.
When a transport is performed using SYNC/AFFIRM, the primary performs write operations and waits for
acknowledgment that the redo has been transmitted synchronously to the physical standby and written to disk.
A SYNC/AFFIRM transport provides an additional protection benefit at the expense of a performance impact
caused by the time required to complete the I/O to the standby redo log.
Incorrect Answers:
B: When a transport is performed using SYNC/NOAFFIRM, the primary performs write operations and waits
only for acknowledgement that the data has been received on the standby, not that it has been written to disk.
The SYNC/NOAFFIRM transport can provide a performance benefit at the expense of potential exposure to
data loss in a special case of multiple simultaneous failures.
https://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *