RE: Control file relocation
- From: "Hollis, Les" <Les.Hollis@xxxxxx>
- To: <kutrovsky.oracle@xxxxxxxxx>, <oracledbam@xxxxxxxxxxx>
- Date: Tue, 29 Mar 2005 16:36:11 -0600
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
> --
> //www.freelists.org/webpage/oracle-l
>=20
--=20
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
