RE: Control file relocation

With database running (this is assuming you are running on the spfile)

Alter system set controlfiles=3D'location1','location2','location3'
scope=3Dspfile;


Shutdown your instance,
Use OS command to copy controlfiles to new location(s)

Startup






-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Christo Kutrovsky
Sent: Tuesday, March 29, 2005 4:28 PM
To: oracledbam@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Control file relocation

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 =3D ... scope=3Dspfile;

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
>=20
> --
> http://www.freelists.org/webpage/oracle-l
>=20


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

--
http://www.freelists.org/webpage/oracle-l

Other related posts: