1.178 LOG_ARCHIVE_DEST
Use LOG_ARCHIVE_DEST
to specify the destination to which redo log files will be archived.
Property | Description |
---|---|
Parameter type |
String |
Syntax |
|
Default value |
Null |
Modifiable |
|
Modifiable in a PDB |
No |
Range of values |
Any valid path or device name, except raw partitions |
Basic |
No |
Oracle RAC |
Multiple instances can have different values. |
Note:
For Enterprise Edition users, this parameter has been deprecated in favor of the LOG_ARCHIVE_DEST_
n
parameters. If Oracle Enterprise Edition is not installed or it is installed, but you have not specified any LOG_ARCHIVE_DEST_
n
parameters, this parameter is valid.
LOG_ARCHIVE_DEST
is applicable only if you are running the database in ARCHIVELOG
mode or are recovering a database from archived redo logs. LOG_ARCHIVE_DEST
is incompatible with the LOG_ARCHIVE_DEST_
n
parameters, and must be defined as the null string ("") or (' ') when any LOG_ARCHIVE_DEST_
n
parameter has a value other than a null string. Use a text string to specify the default location and root of the disk file or tape device when archiving redo log files. (Archiving to tape is not supported on all operating systems.) The value cannot be a raw partition.
If LOG_ARCHIVE_DEST
is not explicitly defined and all the LOG_ARCHIVE_DEST_
n
parameters have null string values, LOG_ARCHIVE_DEST
is set to an operating system-specific default value on instance startup.
To override the destination that this parameter specifies, either specify a different destination for manual archiving or use the SQL*Plus statement ARCHIVE LOG START
filespec
for automatic archiving, where filespec
is the new archive destination. To permanently change the destination, use the statement ALTER SYSTEM SET LOG_ARCHIVE_DEST =
filespec
, where filespec
is the new archive destination.
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.
See Also:
-
"LOG_ARCHIVE_DUPLEX_DEST", "LOG_ARCHIVE_MIN_SUCCEED_DEST", and "V$ARCHIVE_DEST" for more information on setting this parameter
-
Your Oracle operating system-specific documentation for the default value and for an example of how to specify the destination path or file name using
LOG_ARCHIVE_DEST