This module describes how you can change the destination for archiving of redo log files.
This module discusses the following:
|
Overview | |
|
Temporarily Changing the Destination Using SQL*Plus | |
|
||
|
Permanently Changing the Destination Using EM | |
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.
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:
|
Temporarily Changing the Destination Using SQL*Plus | |
You can also change the value in the initialization parameter file dynamically. Refer to the following sections for detailed instructions:
|
||
|
Permanently Changing the Destination Using EM | |
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.
| 1. |
Invoke SQL*Plus.
|
| 2. |
Issue the following command to change the destination: ARCHIVE LOG START '<your new destination>';
|
| 3. |
Verify your changes: ARCHIVE LOG LIST
|
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.
| 1. |
Invoke SQL*Plus.
|
| 2. |
Issue the ALTER SYSTEM command to update the value of the LOG_ARCHIVE_DEST_n parameter in memory and in your SPFILE: ALTER SYSTEM SET log_archive_dest_1='LOCATION=<your new destination>';
|
| 3. |
Verify your changes: ARCHIVE LOG LIST
|
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.
| 1. |
Select START > Programs > Oracle > OraHome92 > Enterprise Manager Console. Select Launch Standalone and click OK.
|
| 2. |
Expand Databases. Expand your database. Expand Instance and select Configuration. You can change the archive destination on the Recovery page.
|
| 3. |
Click OK to apply your change:
|
Move your mouse over this icon to hide all screenshots