Skip to content
Advertisements

ORA-00600 kcratr_nab_less_than_odr when alter database open fails

This is the issues may occur  after power failures

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[23], [81], [189], [], [], [], [], [], [], []

Solution :

 
Alter database open fails with ORA-00600 kcratr_nab_less_than_odr (Doc ID 1296264.1)


Advertisements
14 Comments Post a comment
  1. Interesting since I had the same issues a few weeks ago. I am curious to know the cause. What there an outage and corruption? Thanks.

    October 14, 2012
  2. Maheshwari Anand #

    I got a solution by this post. Thank U very mutch.

    January 9, 2013
  3. Biswajit Mahapatra #

    i have done the above thing u have mentioned but after the below step
    “SQL> recover database using backup controlfile until cancel;
    ORA-00279: change 1460665 generated at 10/08/2012 08:38:00 needed for thread
    ORA-00289: suggestion :
    D:\APP\MAZAR\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2012_10_14\O1_MF_1_23_%U_.AR
    ORA-00280: change 1460665 for thread 1 is in sequence #23
    Specify log: {=suggested | filename | AUTO | CANCEL}”

    it is showing :- ORA-01194: file 1 needs more recovery to be consistent
    ORA-01110: data file 1: ‘D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF’

    so what i will do please tell me…….

    Regards,
    Biswa

    April 5, 2013
    • abdul basit qamar #

      thanks for the solution

      September 8, 2013
  4. Raghu #

    Thanks ! it worked for me as well !

    October 13, 2014
  5. Nilesh #

    Thanks..It works.

    June 1, 2015
  6. ahmed ali #

    Thank U very mutch

    October 14, 2015
  7. Subhodip Chatterjee #

    followed your steps. worked for my system. thanks !

    January 28, 2016
  8. Marc Strassel #

    Works perfectly ! Thank you Mohamed.

    March 15, 2016
  9. Alex #

    Dear Mohamed
    Thank you for sharing knowledge. Very important article. You saved me a lot of time.
    Thanks

    July 28, 2016
  10. Suresh #

    Dear Mohmed,

    Thank you.. its work like a charm.. Very nice abd appreciate for sharing your knowledge. I was thinking to re-install and tumble on your valuable article.. thanks Suresh

    September 20, 2016
  11. Grit Cerejo #

    Thank you very much. This worked..!!!

    February 28, 2017

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: