Relocate Undo and Redo data files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Relocate Undo and Redo data files

  1. #1
    Join Date
    Feb 2003
    Location
    Peru
    Posts
    39

    Relocate Undo and Redo data files

    can anybody tell me how can i relocate the Undo tablespace data file and the Redo's datafiles to diferent disks of a installed Oracle 9i database running on Redhat 9.0?

    thanks for the help
    Gustavo Villaran

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    first of all read the manual for moving a file, quite asy to find

    all you need to do is take the tablespace offline or startup mount move the os copy, move it in the database and restart.

  3. #3
    Join Date
    Feb 2003
    Location
    Peru
    Posts
    39
    well, first if u dont know yet, in 9i Undo Tablespace cant be offline.

    that's why i ask this...

    thanks anyway
    Gustavo Villaran

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    in that case startup nomount or mount can't remember which one and move the datafile that way

  5. #5
    Join Date
    Feb 2003
    Location
    Peru
    Posts
    39
    i have try that too.

    and Oracle accepts the alter command, but when i startup it points to the original position again.

    dont know why, im trying to search in tahiti but cant find anything yet.
    Gustavo Villaran

  6. #6
    Join Date
    Feb 2001
    Posts
    295
    1. Create a new UNDO_TABLESPACE
    2. Type "ALTER SYSTEM SET UNDO_TABLESPACE=NEW TABLESPACE". If using pfile, change the parameter on init.ora. If using spfile add the clause SCOPE=BOTH

    All the active transactions will remain using the actual tablespace, but the new ones will be addressed to the new undo tablespace. Once the active transactions finish, you can put your old tablespace offline and then drop it, until then it will be "PENDING OFFLINE".

    About the redo logs, just create new groups and drop the old ones. Remember you must have at least 2 groups at any given time, so you'll need to "add a new one/remove an old one" and so on.
    An ounce of action is worth a ton of theory.
    —Friedrich Engels

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