moving archive log directory

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,
[email protected]

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.

excellent....thank you..

-lacey

Quote:

---

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

Hi,

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

Sanjay