Resolved ORA-00600: internal error code, arguments:

Error: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],[210],[39496], [39684], [], [], [], [], [], [], []

STEP 1:

Run SQL Plus command Line

C:Userssan>connect sys as sysdba

SQL> startup
ORACLE instance started.

Total System Global Area 3307048960 bytes
Fixed Size                  2180264 bytes
Variable Size            2046823256 bytes
Database Buffers         1241513984 bytes
Redo Buffers               16531456 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[210], [39496], [39684], [], [], [], [], [], [], []

STEP 2: Shut down the database and startup in mount state

SQL> shut immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.

SQL> startup mount
ORACLE instance started.

Total System Global Area 3307048960 bytes
Fixed Size                  2180264 bytes
Variable Size            2046823256 bytes
Database Buffers         1241513984 bytes
Redo Buffers               16531456 bytes
Database mounted.

STEP 3: Take backup of control file manually at os level using cp or copy command.

SQL> show parameter control_files;

NAME                                 TYPE        VALUE
———————————— ———– ——————————
control_files                        string      C:APPSANORADATAORCL
CONTROL01.CTL, C:APPSAN
FLASH_RECOVERY_AREAORCLCON
TROL02.CTL

STEP 4: Check the Current Logfile 

SQL> select a.member,a.group#,b.status from v$logfile a ,v$log b where a.group#=b.group# and b.status=’CURRENT’ ;

MEMBER
——————————————————————————–
GROUP# STATUS
———- —————-
C:APPSANORADATAORCLREDO03.LOG
3 CURRENT

STEP 5: Shutdown the DB and startup in Mount state

SQL> Shutdown abort ;
ORACLE instance shut down.

SQL> Startup mount ;
ORACLE instance started.

Total System Global Area 3307048960 bytes
Fixed Size                  2180264 bytes
Variable Size            2046823256 bytes
Database Buffers         1241513984 bytes
Redo Buffers               16531456 bytes
Database mounted.

STEP 6: Recover the database using backup controlfile until cancel.

SQL> recover database using backup controlfile until cancel ; — Run this command
ORA-00279: change 2737135 generated at 12/27/2020 12:21:37 needed for thread 1
ORA-00289: suggestion :
C:APPSANFLASH_RECOVERY_AREAORCLARCHIVELOG2018_01_03O1_MF_1_210_%U_.
ARC
ORA-00280: change 2737135 for thread 1 is in sequence #210

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
C:APPSANORADATAORCLREDO03.LOG
Log applied.
Media recovery complete.
SQL>

STEP 7: Reset the logs and re-open the database

SQL> Alter database open resetlogs ;

Database altered.

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit;

 

C:Userssan>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 3 15:00:37 2020

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 3307048960 bytes
Fixed Size                  2180264 bytes
Variable Size            2046823256 bytes
Database Buffers         1241513984 bytes
Redo Buffers               16531456 bytes
Database mounted.
Database opened.
SQL>