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 identify the network transmission mode
B. LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby
C. AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously
D. PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database
Answer: A, B, C
Explanation:
The LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database with three attributes: SYNC or ASYNC for the network transmission mode, LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby and AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously.
Incorrect Answers
D: There is no PROTECTED or UNPROTECTED attribute for the LOG_ARCHIVE_DEST_n initialization parameter.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 51-74
Chapter 2: Availability Enhancements
Oracle 9i New Features, Robert Freeman, p. 86-99
Chapter 3: New Oracle9i Availability and Recoverability Features
No comments:
Post a Comment