Multiple choice

The LOG_ARCHIVE_START initialization parameter for NOARCHIVELOG mode database is set to 'TRUE'. The ARCn processes are not automatically copying the online redo log files. While troubleshooting, it was verified that valid archived redo log file destinations are provided using the LOG_ARCHIVE_DEST_n initialization parameters, yet no files are written to these destinations. What should be done next?

  1. Refresh the current online redo log files.

  2. Switch the database from NOARCHIVELOG to ARCHIVELOG mode.

  3. Issue the 'ALTER SYSTEM ARCHIVE LOG START' statement to activate the ARCn processes.

  4. Shut down and restart the database to activate the ARCn processes.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The LOG_ARCHIVE_START parameter only controls automatic archiving in ARCHIVELOG mode, not NOARCHIVELOG mode. In NOARCHIVELOG mode, automatic redo log archiving is not possible regardless of parameter settings because the database doesn't maintain archive log destinations. Even though valid LOG_ARCHIVE_DEST_n parameters are set, they are ignored in NOARCHIVELOG mode. To enable automatic archiving by ARCn processes, the database must be switched to ARCHIVELOG mode using ALTER DATABASE ARCHIVELOG.

Keep practicing — related questions