tyring to move control files/path in ini file

[castlerock]

I am using SPFILE??? How to move controlfile from one location to another?Pls let me know the steps to do it.

Many Thanks,

[waitecj]

somthing like:

shutdown
move files to new location
startup nomount
alter system set control_files='new location'
alter database open;

[castlerock]

Attempting to move CONTROL files (CONTROL01/02/03.CTL) into directories differing from the installation default directory location results in this "memory realm" error.

TO move these files I am following proper procedures of
1) stopping instance
2) moving the control01/02/03.ctl files to desired directories, 3
) modifying INIT.ora initialization file to reflect proper new path for each file,
4) restart instance.

After restarting the instance its not taking the controlfile in the new location. Deleting the controlfile from old location and starting restarting the db having memory realm" error.

Pls advice if i am wrong...

I am following these steps.

Shutdown the database
copy the the controlfiles from old to new location
startup nomount
alter system set control_files='new location"
alter database open

Many Thanks,

[adewri]

You can also try creating pfile from spfile.

CREATE PFILE FROM SPFILE;
Shutdown the database.
Copy control file to new location.
Make changes in the pfile to point control_file to new location.
Login to sqlplus as sysdba.
Create spfile from pfile.
Startup the database.

HTH

[castlerock]

Thanks a lot

[pando]

alter system set control_files='new location" will not work, you must edit your pfile

[adewri]

I knew something was wrong and Pando pointed it out

[waitecj]

Ooh yes, my bad. Just got to work and tried it. Sorry Castlerock.