Changing the Archive Log Destination
Changing the Archive Log Destination
This module describes how you can change the destination for
archiving of redo log files.
This module discusses the following:
Move your mouse over this icon to show all screenshots.
You can also move your mouse over each individual icon to see only the screenshot
associated with it.
Back to List of Topics
In this module you will learn how to change the destination
for archived redo log files. You can do this by overriding the setting in the
initialization parameter file for the current instance. When you restart your
instance the value will return to the value set in the initialization parameter
file. Refer to the following section for detailed instructions:
You can also change the value in the initialization parameter
file dynamically. Refer to the following sections for detailed instructions:
Back to List of Topics
If you are automatically archiving, you can use the following
command to override the destination specified by the LOG_ARCHIVE_DEST.
This command does not change the value in the initialization parameter file.
This change is only valid until you restart the instance.
Back to List of Topics
To permanently change the destination, you must change the
initialization parameter. You can change it dynamically with the ALTER
SYSTEM command as shown below.
Note: LOG_ARCHIVE_DEST
has been deprecated in favor of LOG_ARCHIVE_DEST_n
for Enterprise Edition users. If you do not have Enterprise Edition or you have
not specified any LOG_ARCHIVE_DEST_n
parameters, LOG_ARCHIVE_DEST
is valid.
Back to List of Topics
If you are automatically archiving, you can change the destination
specified by the LOG_ARCHIVE_DEST by
performing these steps. This operation updates the value of LOG_ARCHIVE_DEST(n)
in your SPFILE.
Note: Oracle Enterprise Manager 9.2 was used in the
examples.
Move your mouse over this icon to hide all screenshots
| 
