ITPub博客

首页 > Linux操作系统 > Linux操作系统 > log_archive_format

log_archive_format

原创 Linux操作系统 作者:Jack_Miller 时间:2012-03-27 19:58:58 0 删除 编辑

LOG_ARCHIVE_FORMAT

PropertyDescription
Parameter typeString
SyntaxLOG_ARCHIVE_FORMAT = filename
Default valueOperating system-dependent
ModifiableNo
Range of valuesAny string that resolves to a valid filename
BasicNo
Real Application ClustersMultiple 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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 索引聚簇表
请登录后发表评论 登录
全部评论

注册时间:2011-12-09

  • 博文量
    25
  • 访问量
    68531