Changing Archivelog Destination

Temporarily Changing the Destination Using SQL*Plus

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 '';



3. Verify your changes:
ARCHIVE LOG LIST






Permanently Changing the Destination Using SQL*Plus

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=';




3. Verify your changes:
ARCHIVE LOG LIST





Permanently Changing the Destination Using Enterprise Manager

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: