Today, I had an Issue with My Oracle DB V 11.2.0.1 and It was Corrupted due to unexpected power failures More than 10 times 😉 !.
As Its a Test DB, I don`t have regular backups. It was an Internal Error with ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr] As I don`t have complete backup to recover , I can recover using ICR ( Incomplete recovery)
1. connect to sys
2. select open_mode from v$database
3. alter database open; – you will be getting internal error code
4. recover database until cancel using backup controlfile;
enter CANCEL
5. alter database open resetlogs;
restart the database to check
https://sriramoracle.wordpress.com/about/
Thanks to Sriram Sanka for his useful Post