Control file recovery

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

Solution

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: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp