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: , , , , , , ,  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: 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