Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Initialization Parameters, 83 of 188


LOG_ARCHIVE_FORMAT

Parameter type: 

String 

Syntax: 

LOG_ARCHIVE_FORMAT = filename 

Parameter class: 

Static 

Default value: 

Operating system dependent 

Range of values: 

Any string that resolves to a valid filename 

Oracle Parallel Server: 

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 is:

LOG_ARCHIVE_FORMAT = "LOG%s_%t.ARC"
See Also:  


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index