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

ORA-00600: internal error code, arguments: [3716], [], [], [], [], [], [], []
ORA-600 signalled during: ALTER DATABASE OPEN…
Wed Mar 18 21:56:19 2009
Trace dumping is performing id=[cdmp_20090318215619]
Wed Mar 18 21:56:22 2009
Shutting down instance (abort)
License high water mark = 10
Instance terminated by USER, pid = 1716436


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.