
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