Installing the Agent › Perform Post-Installation Tasks › Automatic Archiving › Enable Automatic Archiving for Oracle Installation Using PFILE

Enable Automatic Archiving for Oracle Installation Using PFILE

To configure the database for automatic archiving if your Oracle installation is configured to use PFILE, add the following log parameter lines to the INIT(SID).ORA file in your $ORACLE_HOME/dbs directory:

LOG_ARCHIVE_START=TRUE
LOG_ARCHIVE_DEST=<archive log directory>
LOG_ARCHIVE_FORMAT=%t_%s.dbf 

Some of the log parameters include the following:

• LOG_ARCHIVE_START--Enables automatic archiving.
• LOG_ARCHIVE_DEST--Specifies the path to the archived redo log files. The Agent for Oracle queries Oracle Server parameters for the archive log destination in the following order: LOG_ARCHIV_DEST, LOG_ARCHIVE_DEST_1 and so on through LOG_ARCHIVE_DEST_10. The agent backs up the archive logs from the first local destination it finds.
• LOG_ARCHIVE_FORMAT--Specifies the filename format for the archived redo log files where %S specifies the log sequence number and %T specifies the thread number. For example, “ARC%S.%T” is acceptable.

  Important! Use a separator between numerical values. For example, %S.%T. If you omit the separator, archive log file names cannot be parsed because there is no way to determine which part is %S and which part is %T. In addition, this could inadvertently create multiple archive logs with the same name.