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
Smart way of Technology 