331 views
in ControlFiles by ACE (20,920 points)

1 Answer

by ACE (20,920 points)
 
Best answer
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.
...