Change the Archive destination in Oracle

Change the Archive destination in Oracle

1. Check the current location of Archive Destination.


-- login with SYS user and check with command:
archive log list;

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination C:\oracle\archive
Oldest online log sequence 27
Next log sequence to archive 30
Current log sequence 30

SQL> show parameter log_archive_dest_1

NAME                   TYPE        VALUE
---------------------- ----------- ------------------------------
log_archive_dest_1     string      LOCATION=C:\oracle\archive
log_archive_dest_10    string

2. Change the Parameter value with SCOPE=BOTH for permanent.

alter system set log_archive_dest_1='LOCATION=D:\oracle\archive' scope=both;

3. Verified the location of archive is changed.

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination D:\oracle\archive
Oldest online log sequence 27
Next log sequence to archive 30
Current log sequence 30

SQL> show parameter log_archive_dest_1

NAME                   TYPE        VALUE
---------------------- ----------- ------------------------------
log_archive_dest_1     string      LOCATION=D:\oracle\archive
log_archive_dest_10    string

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.