log_archive_format
LOG_ARCHIVE_FORMAT
| Property | Description |
|---|---|
| Parameter type | String |
| Syntax | LOG_ARCHIVE_FORMAT = filename |
| Default value | Operating system-dependent |
| Modifiable | No |
| Range of values | Any string that resolves to a valid filename |
| Basic | No |
| 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
%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
(每做一次resetlogs操作，数据库相当于重新拥有了一个肉身，所以使用incarnations)
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%t_%s_%r.arc'
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25791987/viewspace-719671/ ，如需转载，请注明出处，否则将追究法律责任。
