LOG_ARCHIVE_FORMAT

Parameter type	String
Syntax	LOG_ARCHIVE_FORMAT = filename
Default value	Operating system-dependent
Parameter class	Static
Range of values	Any string that resolves to a valid filename
Real Application Clusters	Multiple instances can have different values, but identical values are recommended.

LOG_ARCHIVE_FORMAT is applicable only if you are using the redo log in ARCHIVELOG mode. Use a text string and variables to specify the default filename format when archiving redo log files. The string generated from this format is appended to the string specified in the LOG_ARCHIVE_DEST parameter.

The following variables can be used in the format:

%s log sequence number

%S log sequence number, zero filled

%t thread number

%T thread number, zero filled

Using uppercase letters for the variables (for example, %S) causes the value to be fixed length and padded to the left with zeros. An example of specifying the archive redo log filename format follows:

LOG_ARCHIVE_FORMAT = "LOG%s_%t.ARC"

Neither LOG_ARCHIVE_DEST nor LOG_ARCHIVE_FORMAT have to be complete file or directory specifiers themselves; they only need to form a valid file path after the variables are substituted into LOG_ARCHIVE_FORMAT and the two parameters are concatenated together.

See Also: Oracle9i User-Managed Backup and Recovery Guide and Oracle9i Real Application Clusters Administration for more information on setting this parameter Your operating system- specific Oracle documentation for the default value and range of values for LOG_ARCHIVE_FORMAT