Multiple choice

The ARCn processers are writing online redo log files to one local mandatory destination, one local optional destination, and one remote mandatory destination. The LOG_ARCHIVE_MIN_SUCCEED_DEST parameter is set to 2. What effect does this parameter have on the automatic archival process?

  1. After the archival of online redo log files to the two mandatory destinations occurs, the online redo logs may be overwritten.

  2. After the archival of online redo log files to the two local destinations occurs, the online redo logs may be overwritten.

  3. No effect because the LOG_ARCHIVE_MIN_SUCCEED_DEST parameter value is not equal to the number of local mandatory archive destinations.

  4. After the archival of online redo log files to the one local mandatory destination occurs, the online redo logs may be overwritten.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

LOG_ARCHIVE_MIN_SUCCEED_DEST=2 means archival must succeed to at least 2 destinations before redo logs can be overwritten. The destinations include 1 local mandatory + 1 local optional = 2 local destinations. The remote mandatory is the third destination but isn't counted for the minimum since we already have 2 local ones. Option B correctly identifies that archival to both local destinations is sufficient.

Keep practicing — related questions