Multiple choice

The first step in placing a database into ARCHIVELOG mode has been performed. The second step is deciding whether the online redo log files are to be archived automatically or manually. Which action should be taken to enable archiving at instance startup?

  1. Immediately after setting the database in ARCHIVELOG mode, in SQL*Plus select automatic archiving using this syntax: ALTER DATABASE SET LOG_ARCHIVE_START=TRUE.

  2. Automatic archiving is the default when ARCHIVELOG mode is set. No further actions are required.

  3. Set the LOG_ARCHIVE_MAX_PROCESSES parameter to n (where n is the number of Archiver processes) in the initialization parameter file.

  4. Set the LOG_ARCHIVE_START parameter to TRUE in the initialization parameter file.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The correct answer is D because LOG_ARCHIVE_START is the initialization parameter that enables automatic archiving when set to TRUE. Option A is incorrect because ALTER DATABASE SET LOG_ARCHIVE_START is not valid syntax. Option B is incorrect because automatic archiving is not the default. Option C is incorrect because LOG_ARCHIVE_MAX_PROCESSES controls the number of archiver processes, not whether archiving is enabled.

Keep practicing — related questions