0 Remove / Delete Control File Oracle

Remove or Delete a Control File Oracle.
 
How to delete a Control File Oracle?
We will remove the control file F:\Database\CONTROL03.CTL.

Two methods depending on the configuration PFILE or SPFILE in place.

If you use the static parameter file PFILE.

Edit the PFILE is appointing initSID.ora and delete
CONTROL_FILES Part F:\Database\ CONTROL03.CTL
CONTROL_FILES = ('C:oracledba\oradata\test_database\control.ctl   'D:\DATABASE\CONTROL02.CTL','F:\DATABASE\CONTROL03.CTL')
  
Close the database
    SQL> shutdown immediate;
 then restart the database.
    SQL> STARTUP
    SQL> SHOW PARAMETER CONTROL_FILES;

If you use the server parameter file SPFILE.

With alter system set
     SQL> ALTER SYSTEM SET CONTROL_FILES = 'C:oracledba\oradata\test_database\control.ctl   'D:\DATABASE\CONTROL02.CTL' SCOPE = SPFILE;
  Close the database
    SQL> shutdown immediate;
then restart the database.
    SQL> STARTUP
                    SQL> SHOW PARAMETER CONTROL_FILES;