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

With LOG_ARCHIVE_MIN_SUCCEED_DEST=2, Oracle requires successful archival to at least 2 destinations before overwriting redo logs. Since there are 2 local destinations (1 mandatory + 1 optional), once both local destinations succeed, the requirement is met even if the remote destination hasn't finished.

Keep practicing — related questions