Multiple choice technology databases

Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database? (Choose three)

  1. SYNC or ASYNC to identify the network transmission mode.

  2. LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby.

  3. AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously.

  4. PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

LOG_ARCHIVE_DEST_n parameters control Data Guard availability through three key attributes: SYNC/ASYNC defines network transmission mode (synchronous for zero data loss, asynchronous for better performance), LGWR/ARCH specifies which primary process sends redo (LGWR for real-time, ARCH for archived logs), and AFFIRM/NOAFFIRM controls whether disk writes are synchronous (AFFIRM) or asynchronous (NOAFFIRM) at the standby. PROTECTED/UNPROTECTED is not a valid parameter - data protection modes are set at the database level, not per destination.

Keep practicing — related questions