Tuesday, June 14, 2011

ORA-00600: internal error code, arguments: [2662], [a], [b], [c], [d], [], [], []


Recently I have faced an ORA-600 error, below is the details.....

ORA-00600: internal error code, arguments: [2662], [a], [b], [c], [d], [], [], []
ORA-00600: internal error code, arguments: [2662], [2728], [3808184538], [2728], [3808343262], [4207314], [], []
ORA-00600: internal error code, arguments: [2662], [2728], [3808384312], [2728], [3808417933], [8388617], [], []
ORA-00600: internal error code, arguments: [2663], [2728], [3808404316], [2728], [3808417933], [], [], []

This is due to mismatch of SCN (Current and one in the UGA)

If you open the database using resetlogs then the SCN in column d will change,so open without resetlogs;

if recovery is needed just do recover database instead of recove database using backup controlfile;


Bounce the database mutliple times if the difference is small.
of set the below event to increment the SCN so that multiple bounce will help you open the database without any errrors.

alter session set events '10015 trace name adjust_scn level 10';

No comments:

Post a Comment