How to Change Archive Log Destination in Oracle?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

This how-to guide shows how to change the archive log destination in Oracle in 5 easy steps.

How to guide
Changing archive log destination in Oracle.
Confirm the current archive log location before changing it using the following command:
sqlplus / as sysdba
startup
archive log list
Now set the FRA Value using the following command:
alter system set db_recovery_file_dest_size=10g scope=both;
Change FRA directory:
alter system set db_recovery_file_dest='/usr01/oracle/fra scope=both;
Check the status of new archive log location:
archive log list
Switch the redo log file and archive log generated in the FRA location:
alter system switch logfile;

Video Tutorial

Useful Resources

Oracle Docs