Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database? (Choose three.)
A.
SYNC or ASYNC to specify that network I/O is to be done synchronously or asynchronously
B.
LGWR or ARCH to specify the process that will perform archival operations
C.
AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously.
D.
VERIFY and NOVERIFY to verify the correctness of the contents of a completed archived redo log file
Explanation:
The attributes of the LOG_ARCHIVE_DEST_n initialization parameter. The following list shows the attributes:
* AFFIRM and NOAFFIRM (C) Controls whether redo transport services use synchronous or asynchronous I/O towrite redo data to disk
* ALTERNATE
* ARCH and LGWR (B) Specifies whether redo transport services use archiver processes (ARCn) or the log writer process (LGWR) to collect transaction redo data and transmit it to standby destinations. If neither the ARCH or LGWR attributes are
specified, the default is ARCH.
* DB_UNIQUE_NAME
* DELAY
* DEPENDENCY
* LOCATION and SERVICE
* MANDATORY and OPTIONAL
* MAX_CONNECTIONS
* MAX_FAILURE
* NET_TIMEOUT
* NOREGISTER
* REOPEN
* SYNC and ASYNC (A) Specifies that network I/O is to be done synchronously (SYNC) or asynchronously (ASYNC) when archival is performed using the log writer process (LGWR).
* TEMPLATE
* VALID_FOR
* VERIFY
REF.: Oracle(r) Data Guard Concepts and Administration 10g Release 2 (10.2), 14-1