ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle 参数LOG_ARCHIVE_FORMAT 的格式

oracle 参数LOG_ARCHIVE_FORMAT 的格式

原创 Linux操作系统 作者:lfree 时间:2007-05-17 00:00:00 0 删除 编辑
Parameter type String Syntax

LOG_ARCHIVE_FORMAT = filename

Default value

Operating system-dependent

Parameter class

Static

Range of values

Any string that resolves to a valid filename

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

%t thread number

%T thread number, zero filled

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%s_%t.ARC"

Neither LOG_ARCHIVE_DEST nor LOG_ARCHIVE_FORMAT have to be complete file or directory specifiers themselves; they only need to form a valid file path after the variables are substituted into LOG_ARCHIVE_FORMAT and the two parameters are concatenated together.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/267265/viewspace-83032/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 使用asmcmd
请登录后发表评论 登录
全部评论
熟悉oracle相关技术,擅长sql优化,rman备份与恢复,熟悉linux shell编程。

注册时间:2008-01-03

  • 博文量
    2485
  • 访问量
    6290632