Monday, February 17, 2020

How to relocate Controlfile To a new location In Oracle

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;