1- modify the parameter file
2 - shutdown the database
3 - move/copy the controlfile to the new location from the existing
location (do this at the OS level)
4 - start the database up

to verify:
SQL> SELECT name FROM v$controlfile;


Thanks...
Chris


Oracle Engineering
[Email address protected]





"Cal " <oracledba-ezmlmshield-x73861938.[Email address protected]
06/02/04 12:06 PM


To: "LazyDBA.com Discussion" <[Email address protected]
cc:
Subject: Moving a Control File


Hello, on an Oracle 9i system running on Redhat ES 3 a new disk has just
been made available to me and I would like to move one of the control
files to it.

What are the steps\commands to move a control file?

I am not sure what the commands are from SQLPlus logged in as sys to do
this.




---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page