Recovering a Control File

Recovering from Control File Corruption Using a Control File Copy

This procedure assumes that one of the control files specified in the CONTROL_FILES parameter is corrupted, the control file directory is still accessible, and you have a multiplexed copy of the control file.

1. With the instance shut down, use an operating system command to overwrite the bad control file with a good copy:

   % cp /u01/oracle/prod/control03.ctl  /u01/oracle/prod/control02.ctl
   
   

2. Start SQL*Plus and open the database:

   SQL> STARTUP