Multiple choice

A database was started with the command STARTUP PFILE=initEMPLOYEE.ora. A value in the initEMPLOYEE.ora parameter file is LOG_ARCHIVE_START=false. While the database is open, ALTER SYSTEM ARCHIVE LOG START; command was issued to start the Archiver process. The database was shut down to take a backup and restart it using the initEMPLOYEE.ora parameter file again. When the status of the Archiver was checked, it was disabled. Why?

  1. When a backup is taken, the Archiver process is disabled.

  2. The Archiver can only be started by issuing the ALTER DATABASE ARCHIVELOG command.

  3. LOG_ARCHIVE_START is still set to FALSE because the PFILE is not updated when you issue the ALTER SYSTEM command.

  4. The Archiver can only be started by issuing the ALTER SYSTEM ARCHIVE LOG START command each time the database is opened.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

ALTER SYSTEM commands only affect the running instance's memory (SGA). They do not modify the PFILE (text parameter file) on disk. When you restart with the same PFILE, it still contains LOG_ARCHIVE_START=FALSE, so the Archiver remains disabled. To make the change persistent, you need to update the PFILE manually or use SPFILE.

Keep practicing — related questions