if you are using spfile
1) alter system set control_file = '$HOME/ctrl1.ctl', '$HOME/ctrl2.ctl' scope=spfile;
2) shutdown
3) cp $HOME/ctrl1.ctl $HOME/ctrl2.ctl
4) startup
if you are using pfile
1) shutdown
2) cp $HOME/ctrl1.ctl $HOME/ctrl2.ctl
3) add control file name to pfile
control_files = ($HOME/ctrl1.ctl, $HOME/ctrl2.ctl)
4) startup
-----Original Message-----
From: Cal
[mailto:oracledba-ezmlmshield-x73861938.[Email address protected]
Sent: Wednesday, June 02, 2004 12:07 PM
To: LazyDBA.com Discussion
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
For technical support please email [Email address protected] or you can
call (972)721-8257.
This email has been scanned for all viruses by the MessageLabs Email Security System.
************************************************************************
This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material.
************************************************************************
This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to [Email address protected]
Oracle LazyDBA home page