Dropping Control Files in Oracle

Goal:

Dropping Control Files in Oracle

Description:

You can drop control files from the database. For example, you might want to do so if the location of a control file is no longer appropriate. Remember that the database must have at least two control files at all times.

Shut down the database.

Edit the CONTROL_FILES parameter in the database's initialization parameter file to delete the old control file's name.

Restart the database.

Note:

This operation does not physically delete the unwanted control file from the disk. Use operating system commands to delete the unnecessary file after you have dropped the control file from the database.