Parameter type: |
String |
Syntax: |
LOG_ARCHIVE_DEST = filespec |
Parameter class: |
Dynamic. Scope = ALTER SYSTEM. |
Default value: |
None |
Range of values: |
A ny valid path or device name, except raw partitions |
Oracle Parallel Server: |
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 command ARCHIVE LOG START filespec for automatic archiving, where filespec is the new archive destination. To permanently change the destination, use the command ALTER SYSTEM SET LOG_ARCHIVE_DEST = filespec, where filespec is the new archive destination.
See Also:
|