Today,  I had an Issue with My Oracle DB V  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





Thanks to Sriram Sanka for his useful Post