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
- %tthread number
- %Tthread number, zero filled
- %a activation ID
- %d database ID
- %r resetlogs ID that ensures unique names are constructed for the archived log files across multiple incarnations of the database
At least %r%s%t is needed