DBA Hub

📋Steps in this guide1/1

Resolved ORA-00600 internal error code, arguments:

in this blog, I have explained you how to resolve ORA-00600 error. ORA-00600 is the common error in oracle databases

oracle configurationintermediate
by OracleDba
17 views
1

Overview

Resolved ORA-00600 internal error code, arguments:

Code/Command (click line numbers to comment):

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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
oracle@dba>sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 Production on Sun Oct 31 14:17:41 2021

Copyright (c) 1982, 2019, 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.
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[210], [39496], [39684], [], [], [], [], [], [], []

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.

NAME                                 TYPE        VALUE
-------------------------------------------------------
control_files                        string      /data/app/oracle/oradata/ORCL/control01.ctl,
/data/app/oracle/flash_recovery_area/ORCL/control02.ctl

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

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.

SQL> recover database using backup controlfile until cancel ;
ORA-00279: change 2737134 generated at 12/27/2017 12:21:37 needed for thread 1
ORA-00289: suggestion :
/data/app/oracle/oradata/ORCL/fast_recovery_area/arcivelog2018_01_03O1_MF_1_210_%U_.
ARC
ORA-00280: change 2737134 for thread 1 is in sequence #210

Specify log: {=suggested | filename | AUTO | CANCEL}
/data/app/oracle/oradata/ORCL/redo03.log
Log applied.
Media recovery complete.
SQL>

SQL> Alter database open resetlogs ;

Database altered.

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

Disconnected from Oracle Database 19cg Enterprise Edition Release 19.0.0.0.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

C:Userssan>sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 Production on Sun oct 31 15:00:41 2021

Copyright (c) 1982, 2019, 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>
SQL>

Comments (0)

Please to add comments

No comments yet. Be the first to comment!