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

image1

 

 image2

image3

 

https://sriramoracle.wordpress.com/2014/03/19/ora-00600-internal-error-code-arguments-kcratr_nab_less_than_odr/

https://sriramoracle.wordpress.com/about/

Thanks to Sriram Sanka for his useful Post