Goal:
Recovering a Control File Using a Current Copy
Description:
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.
With the instance shut down, use an operating system command to overwrite the bad control file with a good copy:
% cp /u01/oracle/itbl/control03.ctl /u01/oracle/itbl/control02.ctl
Start SQL*Plus and open the database:
SQL> STARTUP
Recovering a Control File Using a Current Copy
Description:
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.
With the instance shut down, use an operating system command to overwrite the bad control file with a good copy:
% cp /u01/oracle/itbl/control03.ctl /u01/oracle/itbl/control02.ctl
Start SQL*Plus and open the database:
SQL> STARTUP
No comments:
Post a Comment