LOG_ARCHIVE_START (Oracle)

This parameter is used to activate (parameter value true) or deactivate (parameter value false) automatic archiving of the online redo log files in the archiving directory (log_archive_dest).

Note

Note: this parameter is deprecated as of Oracle 10g.

The database should always run in ARCHIVELOG mode for productive SAP systems. For a database system to be able to run in this mode, parameter log_archive_start must be set to true. In this case, the background process ARCH is automatically triggered for a redo log file switch in order to start archiving the online redo log files in the group that is just being used. These online redo log files cannot be written again until they have been archived successfully.

If ARCHIVELOG mode is activated and log_archive_start is set to false, the database freezes once all the online redo log files are filled. In this case, the background process ARCH is not triggered in order to write the online redo log files to the archiving directory. However, the online redo log files cannot be overwritten until they are archived.