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 affects ARCHIVELOG mode databases. In NOARCHIVELOG mode, automatic archiving is disabled regardless of this parameter's value. To enable ARCn processes to copy redo logs, you must switch the database to ARCHIVELOG mode using ALTER DATABASE ARCHIVELOG. Only then does LOG_ARCHIVE_START become meaningful.

Keep practicing — related questions