December 2002
Intermediate to advanced
928 pages
85h 29m
English
LOG_ARCHIVE_FORMAT
Value: valid filename format
Default: operating system dependent
Specifies the default filename format when archiving redo log files when running in ARCHIVELOG mode. 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:
Log sequence number
Thread number
The default is operating system dependent, but is usually %t_%s.dbf. Using uppercase letters (for example, %S) for the variables causes the value to be a fixed length padded to the left with zeros.