Oracle7 Server Administrator's Guide

Dropping Control Files

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

To Drop a Control File from a Database

1. Shut down the database.

2. Exit Server Manager.

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

4. Restart Server Manager.

5. Restart the database.

Warning: 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.