My Oracle database have crashed for some reason, and while trying to start up:
SQL> startup
ORACLE instance started.
Total System Global Area 7071333376 bytes
Fixed Size 1675792 bytes
Variable Size 829809390 bytes
Database Buffers 431527320 bytes
Redo Buffers 4405509 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[90], [46191], [46469], [], [], [], [], [], [], []
Solution:
in order to resolve this you need t perform recovery, per the following steps:
SQL>Startup mount ;
SQL>Show parameter control_files
SQL> select a.member, a.group#, b.status from v$logfile a ,v$log b where a.group#=b.group# and b.status=’CURRENT’ ;
remark: write down the name of the redo logs and their paths…
SQL> Shutdown abort ;
remark:Take a OS Level backup of the controlfiles in different directory
SQL> Startup mount ;
SQL> recover database using backup controlfile until cancel ;
Remark: Enter location of redo logsΒ (refer to the query where you have wrote down the location of redologs),then hit ‘Enter’
SQL> Alter database open resetlogs ;
Geodata Master 
it really worked for me….thank you so so much π
you are welcome
This is wonderful with indepth attention to detail! Helped me so much to recover database in crucial moment!
I am happy that my blog is helping IT analysts with ctitical problems….thank you for the kind words.
MAN WTF, I’ve looked up all over the internet and I couldn’t find the solution for ORA-600 but YOU DID! OMG thanks very very much!!
Thanks a lot , worked for me π
Thanks a lot.. this worked for me
Thank you very much, it saved me.
you are welcome
Nice! That also worked for me! π
Thanks. This page really samed my day