What is the best way to change the location of the controlfiles incase the db is already in existance.
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.
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.
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)
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.
Click Here to Expand Forum to Full Width