ORACLE ORA-00600 ERROR SOLUTION

Some time we get a error from oracle, ORA-00600, and here is the solution for that.

PROBLEM :

ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[260], [12510], [12578], [], [], [], [], [], [], []


SOLUTION :

SQL> conn
SQL>sys as sysdba
SQL>password

SQL> Startup mount;

SQL>Show parameter control_files;

             Will give the list of the control files with full path of the 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';

    Will give redo log file not down name of the redolog file with full path.

SQL>recover database using backup controlfile until cancel;

    Write the full Path of redolog file when asked.
    And hit enter.
    Will Give message "Log Applied. Media recovery complete."
   
SQL>alter database open resetlogs;
   
    Will give message "Database altered."

Now connect as your local user.

















IF YOU HAVE ANOTHER WAY TO SOLVE IT PLEASE SHARE IT AS COMMENT