moving archive log directory
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: moving archive log directory

  1. #1
    Join Date
    Dec 2000
    Posts
    15

    Lightbulb

    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

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  3. #3
    Join Date
    Dec 2000
    Posts
    15
    excellent....thank you..

    -lacey

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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
  •  



Click Here to Expand Forum to Full Width