[Oracle] Restoring the Control File from the Autobackup

If somehow the control files were deleted or corrupted, we are going to show you how to restore and recover the database with a control file restored from a control file and SPILE autobackup.

> Identify the control file locations where all copies of the control file used to reside

SQL> show parameter control_files

> Shut down the instance and reopen it in NOMOUNT mode

SQL> shutdown immediate;

SQL> startup force nomount;

> Start RMAN and restore the control file from autobackup to the original locations

RMAN> restore controlfile from autobabckup;

RMAN has to connect to an unmounted database to be able to restore the control file. RMAN finds the control file autobackup in the flash recovery area and writes it to the three control fil destinations specified by the CONTROL_FILES initialization parameter.

> Mount the database, recover it and open the database with RESETLOGS

RMAN> alter database mount;

RMAN> recover database;

RMAN> alter database open resetlogs;

see also : [Oracle] Restore database (PITR)