Recovering from Permanent Media Failure Using a Control File Copy

Goal:
Recovering from Permanent Media Failure Using a Control File Copy

Description:

This procedure assumes that one of the control files specified in the CONTROL_FILES parameter is inaccessible due to a permanent media failure, and you have a multiplexed copy of the control file.

With the instance shut down, use an operating system command to copy the current copy of the control file to a new, accessible location:

% cp /u01/oracle/itbl/control01.ctl  /u04/oracle/itbl/control03.ctl

Edit the CONTROL_FILES parameter in the initialization parameter file to replace the bad location with the new location:

CONTROL_FILES = (/u01/oracle/itbl/control01.ctl,
                 /u02/oracle/itbl/control02.ctl, 
                 /u04/oracle/itbl/control03.ctl)

Start SQL*Plus and open the database:


SQL> STARTUP