moving archive log directory

[lacey]

I would like to build a new directory to store my archived log files and remove the old one......does anyone know the steps I would have to take??? I believe I would have to shutdown the database and modify some init parameters....is there anything I need to do for the control file....does anyone know the parameters that must be modified????

thanks,
h00p3s@yahoo.com

[jmodic]

You only have to change your LOG_ARCHIVE_DEST parameter in the init.ora and restart the database. Controlfile has nothing to do with the archived logs destination.

[lacey]

excellent....thank you..

-lacey

[marist89]

Originally posted by jmodic
You only have to change your LOG_ARCHIVE_DEST parameter in the init.ora and restart the database. Controlfile has nothing to do with the archived logs destination.

actually, you can switch archiving on the fly if you are on 8.1.x. Basically, you stop archiving, switch archive location, and restart archiving. You can change the log_archive_dest at a later point for your next database bounce.

ALTER SYSTEM ARCHIVE LOG STOP;
ALTER SYSTEM ARCHIVE LOG START TO '/u01/newloc';

[SANJAY_G]

Hi,

You can switch archive log destination "on the fly" as marist89 suggested in 7.3.4 also.

Sanjay