Multiple choice

How can automatic archiving at instance startup be enabled for a ARCHIVELOG database?

  1. With the database open, issue the 'ARCHIVE LOG START ALL' SQL*Plus command.

  2. With the database shut down, set the LOG_ARCHIVE_START initialization parameter to 'TRUE'.

  3. With the database mounted, issue the 'ALTER DATABASE ARCHIVELOG' SQL statement.

  4. With the database open, issue the 'ALTER SYSTEM ARCHIVE LOG START TO <file_name>' SQL statement.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The LOG_ARCHIVE_START parameter controls automatic archiving at instance startup. Setting it to TRUE in the initialization parameter file enables automatic archiving when the database starts up. Option A is incorrect because ARCHIVE LOG START is a runtime command, not a startup configuration. Option C places the database in ARCHIVELOG mode but does not enable automatic archiving at startup. Option D describes a manual archive command, not automatic startup archiving.

Keep practicing — related questions