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,
Last edited by castlerock; 07-14-2005 at 11:41 AM.
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
Amar "There is a difference between knowing the path and walking the path."