Hello,
i want to update control file path but unable to do so. kindly check my steps and correct me what i'm making misstake, oracle 11g r2 on windows
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
move all files in files folder
SQL> STARTUP NOMOUNT;
ORACLE instance started.
Total System Global Area 293601280 bytes
Fixed Size 1248624 bytes
Variable Size 92275344 bytes
Database Buffers 197132288 bytes
Redo Buffers 2945024 bytes
SQL> alter system set control_files='E:\FILES\CONTROL01.CTL','E:\FILES\CONTROL02
.CTL','E:\FILES\CONTROL03.CTL' scope=spfile;
System altered.
SQL> ALTER DATABASE MOUNT;
ALTER DATABASE MOUNT
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
when i checked it logfile it still holding the old path and try to read control file from old location
kindly correct me if i committed any mistake here