Archiving Parameters

The following parameters in the init.ora file control the archiving process:

Parameter	Note
log_archive_start = true	Preset by SAP
log_archive_dest = /	Part of the file name
log_archive_format = ORACLE default	Use the ORACLE default

The parameter log_archive_start = true causes the archive process to be started automatically when the database is started. The automatic archival mode is set to enabled.

The parameter log_archive_dest defines the archive directory of the online redo log files for archiving. It is delivered with the specification of the following SAP standard path (example for a single instance installation):

BS> /saparch/arch

See Environment Variables

Prerequisites

• The corresponding archive directory (under UNIX:
saparch) must exist.
• Make sure that the directory is not write-protected.
• Make sure that the directory has enough free space. Otherwise, the archiving process cannot archive any log files and no further actions are possible on the database (Archiver Stuck).

The Oracle database interprets the string arch as the prefix of a file name that, together with an appended sequential number (log sequence number), names the offline redo log files.

You can archive these offline redo log files (online redo log files saved in the archive directory) with the SAP utility BRARCHIVE.
See Archiving the Offline Redo Log Files.

Configuration with SAPDBA

When automatic archiving of the online redo log files is not active, you can activate it using the SAPDBA menu. To do this, choose Archive Mode ® Toggle automatic archival.
See SAPDBA: Archive Mode.

Configuration with SVRMGR

After starting up an instance, you can also use the Oracle program SQLDBA to start and stop the archiving process.

Command for starting the ARCH process:

SVRMGR> connect internal

SVRMGR> alter system archive log start;

SVRMGR> archive log list

When enabled appears in the automatic archival display, this means you have correctly activated the automatic archiving.