If your database contains multiple copies of the control file, you can replace a corrupted control file by manually copying from an existing control file and restoring it.
Follow the steps given below to restore a control file from an existing control file:
-
Shut down the database.
SQL> shutdown
-
Manually copy one of the existing control files to the missing control file location.
-
Assign the same owner, group and file permissions to the new control file as that of the original missing control file.
-
Start up the database.
SQL> startup nomount;