SOLVED

Resolved ORA-00600 internal error code, arguments:

Asked by OracleDba••26 views•oracle
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
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.

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], [], [], [], [], [], [], []

Re
#oracle#error

Solutions(1)

Accepted Solution
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
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
-

Step 1 : - shutdown the database and startup in mount stage

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 2: Take backup of control file manually at os level using copy or cp command.

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

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

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 5: Recover the database using backup controlfile until cancel.

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>

STEP 6: Reset the logs and open the database

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>
OracleDba•

Post Your Solution