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)
14 Comments
Post a comment
DBA 
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.
I got a solution by this post. Thank U very mutch.
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
thanks for the solution
Thanks ! it worked for me as well !
Thanks..It works.
You’re welcome
Thank U very mutch
followed your steps. worked for my system. thanks !
Works perfectly ! Thank you Mohamed.
Dear Mohamed
Thank you for sharing knowledge. Very important article. You saved me a lot of time.
Thanks
You’re Welcome
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
Thank you very much. This worked..!!!