Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2007
    Posts
    8

    Unanswered: Change Location of Redo Logs - Oracle 9i

    Hi - I am setting up auto archiving on Oracle 9i. I am sending my archive logs to a drive that is different from the database for backup purposes. I was also thinking I would have my redo logs written there as well, but don't know how to change the destination. For the archive logs I used "alter system set log_archive_dest = 'E:\Archive';"

    Is there something similar I can use to change the destination of the redo logs as well?

    Thanks in advance for your help. Much appreciated.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Is there something similar I can use to change the destination of the redo logs as well?
    NO.
    You have a couple of alternatives.
    1) do a clean shutdown of your database & then copy/rename them to the new location
    2) create new redo log files in the new location; manually switch until new one(s) being used; then remove the old ones.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2007
    Posts
    8
    Thanks for the reply, but I want them to automatically be written to a different directory (a different drive actually). I have used "alter system set log_archive_dest" to relocate the path of my archive files. Is there a command that I can use to do that with my redo.log files as well?

    Thanks

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    What part of "NO" do you NOT understand?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Mar 2007
    Posts
    8
    I clearly understand "NO", yet I am glad I continued doing research. Did you read my question??

    Here is an example of the type of information I was looking for.

    ALTER DATABASE
    RENAME FILE '/diska/logs/log1a.rdo', '/diska/logs/log2a.rdo'
    TO '/diskc/logs/log1c.rdo', '/diskc/logs/log2c.rdo';

    So, in fact the answer is "YES", there is something similar to the command for modification of the archive log destination. As long as you shutdown the db, copy the current redo log files to the desired destination, open the database without mounting it, execute the alter database command (as detailed in the example above) and then proceed to open the db it works fine.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    How does your solution differ from
    >1) do a clean shutdown of your database & then copy/rename them to the new location
    which I posted on 05-08-07 13:01
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Mar 2007
    Posts
    8
    I was specifically looking for something similar to "alter...". This method does not require a shutdown of the db either. You can just roll through them by forcing a switch in the active log file. I also used this method to setup multiplexing the log files over multiple spans and it works fine. No db shutdown was required.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •