Re: Control file relocation

  • From: Christo Kutrovsky <kutrovsky.oracle@xxxxxxxxx>
  • To: oracledbam@xxxxxxxxxxx
  • Date: Tue, 29 Mar 2005 17:28:29 -0500

You have several options.

- You can create init.ora and spfiles while your database is down, fro
meach other. So you can just create init.ora file, make change, create
spfile, remove init.ora file, startup normal.

- You can also make the change ahead of time via alter system set
control_files = ... scope=spfile;

then bounce.


Christo Kutrovsky
Database/System Administrator
The Pythian Group



On Tue, 29 Mar 2005 13:58:51 -0500, Seema Singh <oracledbam@xxxxxxxxxxx> wrote:
> Hi,
> How to relocate controlfile in 9i thru spfile?
> thanks
> 
> --
> //www.freelists.org/webpage/oracle-l
> 


-- 
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
//www.freelists.org/webpage/oracle-l

Other related posts: