multiplexing controlfile

Do you know what happens when you startup nomount ? If you have not figured out.................Then

do the 4th step before step 1 and you are good to go. :)

Quote:

---

Originally Posted by seyiisq

I connected as sysdba did the following

1)shutdown immediate
2)copy the controlfile successfully to new directory using the
os command
3)startup (Just do this)

4)Then i i tried setting the control file to the new one but got the error below.

---

create pfile='/somepath/pfile' from spfile;
then go to that directory
and open the pfile with vi ,or notepad(windows).
Change the lines about control files;
Like;
*.control_files='/ora9db/oradata/HISDB/control01.ctl','/oradb/oradata/HISDB/control02.ctl','/ora9db/oradata/HISDB/control03.ctl'

then save it.
now shutdown the database;
and finally startup with that newly created pfile.
startup pfile='/somepath/pfile'.

bytheway, it doesnt mean that,if the database uses a spfile,the parameter can be changed dynamically.
If the parameter is non session or system modifiable,you cant modify it during runtime.