Skip to Main Content
Oracle Initialization Parameters Pocket Reference
book

Oracle Initialization Parameters Pocket Reference

by David C. Kreines
August 2004
Intermediate to advanced content levelIntermediate to advanced
122 pages
4h 22m
English
O'Reilly Media, Inc.
Content preview from Oracle Initialization Parameters Pocket Reference
LOG_ARCHIVE_LOCAL_FIRST
Parameter Quick Reference
|
59
Oracle recommends that you set LOG_ARCHIVE_DEST_n
instead of this parameter if the Enterprise Edition is used: do not
use both.
LOG_ARCHIVE_FORMAT
Value:
String containing filename format
Default:
Operating system dependent
Specifies the filename format for archiving redo log files while
running in ARCHIVELOG mode. The string filename generated
from this format is appended to the directory string specified in
the LOG_ARCHIVE_DEST parameter.
The following variables can be used in the format:
%a Activation ID.
%d Database ID.
%r Resetlogs ID, which causes unique names to be constructed
for archived log files across multiple incarnations of the
database.
%s Log sequence number.
%S Log sequence number, zero-filled.
%t Thread number, which must be specified when using RAC.
%T Thread number, zero-filled.
The default is operating system dependent but is usually %t_%s.
dbf. Using uppercase letters (for example, %S) for a variable
causes the value to be a fixed length padded to the left with zeros.
TIP
In a RAC environment, the thread number must be speci-
fied, using either %t or %T.
LOG_ARCHIVE_LOCAL_FIRST
Value:
TRUE | FALSE
Default:
TRUE
Dynamic:
ALTER SYSTEM
LOG_ARCHIVE_LOCAL_FIRST
60
|
Oracle Initialization Parameters Pocket Reference
Specifies when the archiver processes ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Running Applications on Oracle Exadata

Running Applications on Oracle Exadata

Joyjeet Banerjee

Publisher Resources

ISBN: 9780596528850