RE: Control file relocation

From: Hollis, Les <Les.Hollis_at_ps.net>
Date: Tue, 29 Mar 2005 16:36:11 -0600
Message-ID: <D44DCE7BBC084E4C9E2DA87EC75E8DE33E7A4D@pscdalpexch02.perotsystems.net>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Christo Kutrovsky Sent: Tuesday, March 29, 2005 4:28 PM
To: oracledbam_at_hotmail.com
Cc: oracle-l_at_freelists.org
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_at_hotmail.com> 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

Received on Tue Mar 29 2005 - 17:37:37 CST