Senthil Murugan's Blog

Home » Oracle » ORA-00600: Internal error code, arguments: [kcratr_nab_less_than_odr]

ORA-00600: Internal error code, arguments: [kcratr_nab_less_than_odr]

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: