Backup Options   «Prev 

Reconstructing Control file

  1. After a media failure, you try to start the database. Type
    STARTUP OPEN PFILE=C:\ORANT\DATABASE\INITORCL.ORA
    
    at the prompt and press Enter.
  2. The error message shows that something went wrong with the control file. Suppose that you checked the alert log and found out that the control file was totally corrupted. In addition, you do not have a mirrored copy. However, you do have a backup that you made two days ago via ALTER DATABASE BACKUP CONTROLFILE TO TRACE;. You edited the trace file and saved it with the name CR_CTL_ORCL.SQL. Since your database is mounted, you have to shut it down before you can run the file. Type
    SHUTDOWN IMMEDIATE
    
    at the prompt and press Enter.
  3. To recreate the control file, type
    START C:\ORANT\DATABASE\CR_CTL_ORCL.SQL
    
    at the prompt and press Enter.
  4. If you do not receive an error message, you have successfully recreated the control file and started the database with the new control file. This completes the Simulation.