-
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
-
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.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
excellent....thank you..
-lacey
-
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';
Jeff Hunter
-
Hi,
You can switch archive log destination "on the fly" as marist89 suggested in 7.3.4 also.
Sanjay
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|