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博客 ” ,链接:http://blog.itpub.net/25791987/viewspace-719671/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25791987/viewspace-719671/