nerdexam
Oracle

1Z0-032 · Question #91

You are archiving to four destinations as shown below: LOG_ARCHIVE_DEST_1 = 'LOCATION = /DB01/u01/archive' MANDATORY LOG_ARCHIVE_DEST_2 = 'LOCATION = /DB01/u02/archive' LOG_ARCHIVE_DEST_3 =…

The correct answer is C. set LOG_ARCHIVE_MIN_SUCCEED_DEST=3 for successfully archiving to both MANDATORY. See the full explanation below for the reasoning.

Question

You are archiving to four destinations as shown below:

LOG_ARCHIVE_DEST_1 = 'LOCATION = /DB01/u01/archive' MANDATORY LOG_ARCHIVE_DEST_2 = 'LOCATION = /DB01/u02/archive' LOG_ARCHIVE_DEST_3 = 'LOCATION = /DB01/u03/archive' MANDATORY LOG_ARCHIVE_DEST_4 = 'LOCATION = /DB01/u04/archive' You want to ensure that the archiver successfully archives to at least three of these locations. However, you do not want the system to halt if it cannot write to all four destinations. Which option would you use to accomplish this task?

Options

  • Aset LOG_ARCHIVE_MIN_SUCCEED_DEST=1 for successfully archiving to one OPTIONAL
  • Bset LOG_ARCHIVE_MIN_SUCCEED_DEST=2 for successfully archiving to two OPTIONAL destinations
  • Cset LOG_ARCHIVE_MIN_SUCCEED_DEST=3 for successfully archiving to both MANDATORY
  • Dset LOG_ARCHIVE_MIN_SUCCEED_DEST=4 for successfully archiving to the MANDATORY

How the community answered

(31 responses)
  • A
    6% (2)
  • B
    3% (1)
  • C
    71% (22)
  • D
    19% (6)

Community Discussion

No community discussion yet for this question.

Full 1Z0-032 Practice