Below steps describes for relocating the controlfiles
1. Get the current control_file location
SQL> show parameter control_files
2. Set the new location of controlfile:
SQL> alter system set control_files='\Data\TESTDB\Control01.ctl' scope=spfile;
3. shutdown the database:
4. Move control files physically from old location to new location
5. startup the database
SQL> startup;
No comments:
Post a Comment