DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2000
    What is the best way to change the location of the controlfiles incase the db is already in existance.
    situation 1:
    A new disk is added (disk#3) on the solaris box and already I have 2 controlfiles in each disk. How would I react.. My steps are: Shudown the DB, Edit the init.ora with the 3rd location, copy the controlfile for disk2 to disk3, then bring the database up.. Is this correct.
    Situation 2:
    In my another db I have 2 disks but controlfiles 2 and 3 are in the same disk #2, same directory.. If I have to change the path of the 3rd file alone, I should.. Bring down the db, change the location of the 3rd file by editing the pfile and bring up the database.
    Please confirm.

  2. #2
    Join Date
    Oct 2000
    Situation 1 (you are right about all the steps)

    Situation 2 (you need to MOVE the 3rd file as well besides making changes in the INIT file)

    - Rajeev

  3. #3
    Join Date
    Feb 2000
    Washington DC
    Bottom line:

    By the time you bring up the database, your controlfiles whats you mentioned in config.ora/init.ora should be there. Otherwise you get error, while bringing up the database.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.