Today we are going to have look at the backbone of an Oracle Database. Being DBA we all are most aware of the recovery of the controlfile . It is the most important element of our database. Let’s have a look at the steps which are required for the recovery of controlfile.

Instance terminates on startup with


Take a backup of existing state of controlfile

SQL> Alter database backup controlfile to ‘<Name>’ ;

SQL> Alter database backup controlfile to trace ;

Get the list of Current file backup

Rman> List backup of controlfile ;

Rman> Shutdown immediate ;

Rman> connect target / catalog username/pwd@connectstring

Rman> Startup nomount

Rman> Restore controlfile from ‘<piece handle>’ ;

Rman> recovery database ;

SQL> Alter database open resetlogs;


Now we have recovered the controlfile.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp


About The Author


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.