- 31 Oct, 2021
- 0 Comments
- 2 Mins Read
Resolved ORA-00600 internal error code, arguments:
RESOLVED ORA-00600 INTERNAL ERROR CODE, ARGUMENTS
You might have faced this issue while trying to start the database. Most of the time this ora error occur during database restart after abnormal shutdown or power failure. To resolve it you need to recover the database using backup control file as shown below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | oracle@dba>sqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 Production on Sun Oct 31 14:17:41 2021Copyright (c) 1982, 2019, Oracle. All rights reserved.Connected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 3307048960 bytesFixed Size 2180264 bytesVariable Size 2046823256 bytesDatabase Buffers 1241513984 bytesRedo Buffers 16531456 bytesDatabase mounted.ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],[210], [39496], [39684], [], [], [], [], [], [], [] |
Resolution : -
Step 1 : - shutdown the database and startup in mount stage
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | SQL> shut immediate;ORA-01109: database not openDatabase dismounted.ORACLE instance shut down.SQL> startup mountORACLE instance started.Total System Global Area 3307048960 bytesFixed Size 2180264 bytesVariable Size 2046823256 bytesDatabase Buffers 1241513984 bytesRedo Buffers 16531456 bytesDatabase mounted. |
STEP 2: Take backup of control file manually at os level using copy or cp command.
1 2 3 4 | NAME TYPE VALUE-------------------------------------------------------control_files string /data/app/oracle/oradata/ORCL/control01.ctl,/data/app/oracle/flash_recovery_area/ORCL/control02.ctl |
STEP 3: Check the Current Logfile
1 2 3 4 5 6 7 8 9 | SQL> select a.member,a.group#,b.status from v$logfile a ,v$log b where a.group#=b.group# and b.status=’CURRENT’ 2 ;MEMBER——————————————————————————– GROUP# STATUS———- —————-data/app/oracle/oradata/ORCL/redo03.log 3 CURRENT |
STEP 4: Shutdown the DB and startup in Mount stage
1 2 3 4 5 6 7 8 9 10 11 12 | SQL> Shutdown abort ;ORACLE instance shut down.SQL> Startup mount ;ORACLE instance started.Total System Global Area 3307048960 bytesFixed Size 2180264 bytesVariable Size 2046823256 bytesDatabase Buffers 1241513984 bytesRedo Buffers 16531456 bytesDatabase mounted. |
STEP 5: Recover the database using backup controlfile until cancel.
1 2 3 4 5 6 7 8 9 10 11 12 | SQL> recover database using backup controlfile until cancel ;ORA-00279: change 2737134 generated at 12/27/2017 12:21:37 needed for thread 1ORA-00289: suggestion :/data/app/oracle/oradata/ORCL/fast_recovery_area/arcivelog2018_01_03O1_MF_1_210_%U_.ARCORA-00280: change 2737134 for thread 1 is in sequence #210Specify log: {=suggested | filename | AUTO | CANCEL}/data/app/oracle/oradata/ORCL/redo03.logLog applied.Media recovery complete.SQL> |
STEP 6: Reset the logs and open the database
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 | SQL> Alter database open resetlogs ;Database altered.SQL>SQL>SQL> shut immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> exitDisconnected from Oracle Database 19cg Enterprise Edition Release 19.0.0.0.0 – 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsC:Userssan>sqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 Production on Sun oct 31 15:00:41 2021Copyright (c) 1982, 2019, Oracle. All rights reserved.Connected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 3307048960 bytesFixed Size 2180264 bytesVariable Size 2046823256 bytesDatabase Buffers 1241513984 bytesRedo Buffers 16531456 bytesDatabase mounted.Database opened.SQL>SQL> |