Specify the naming convention to use for archived log files.
Naming archive log files
Just as you must specify a location for archived log files, you must also
specify a naming convention. The log_archive_format initialization parameter is used to do that. The four special character sequences listed here may be used as part of the filename:
The log sequence number. This continually increments as redo log files are produced.
The log thread number, which uniquely identifies the instance producing the log file. This is necessary when the Parallel Server option is being used because the sequence numbers used by multiple instances will overlap.
The log sequence number, but as a fixed-width field padded to the left with zeros.
The thread number as a fixed-width field padded to the left with zeros.
The following mouseover illustrates a couple of typical settings and shows how the resulting filenames will look:
Naming Conventions for Archive Log Files
In the next lesson, you will learn how to enable automatic archiving so that you don't have to archive each log file manually.