ORA-00600: internal error code, arguments: [kddummy_blkchk]

**farenheiit** · 27/05/2009, 00h10

Bonjour,

un de mes développeurs voit sa base tomber toutes les 20 minutes depuis vendredi 22 mai.
En regardant le fichier d'alerte je m'aperçoit qu'au premier plantage l'erreur était la suivante:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
Errors in file c:\ora10\rdbms\trace\ubix_p001_1276.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []

puis au bout de 30 minutes PMON shoot l'instance.
Au prochain démarrage j'obtiens l'erreur suivante:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
Errors in file c:\ora10\rdbms\trace\ubix_p000_2628.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []

J'ai également des erreurs de blocs corrompus

voici le contenu du fichier d'alerte depuis le 22 mai:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
 
Fri May 22 09:33:37 2009
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU                 : 2 - type 586, 2 Physical Cores
Process Affinity    : 0x00000000
Memory (Avail/Total): Ph:1733M/2046M, Ph+PgF:3791M/3939M, VA:1940M/2047M
Fri May 22 09:33:37 2009
Adjusting the default value of parameter parallel_max_servers
from 40 to 35 due to the value of parameter processes (50)
Fri May 22 09:33:37 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as C:\ora10\RDBMS
Autotune of undo retention is turned on. 
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.3.0.
System parameters with non-default values:
  processes                = 50
  timed_statistics         = TRUE
  shared_pool_size         = 83886080
  java_pool_size           = 4194304
  control_files            = C:\ORACLE\ORADATA\UBIX\CTL1UBIX.DBF, C:\ORACLE\ORADATA\UBIX\CTL2UBIX.DBF
  db_block_size            = 4096
  db_cache_size            = 54525952
  compatible               = 9.2.0.0.0
  log_buffer               = 23507968
  log_checkpoint_interval  = 10000
  db_files                 = 20
  db_file_multiblock_read_count= 32
  dml_locks                = 500
  undo_management          = AUTO
  undo_tablespace          = ROLLBACK
  remote_login_passwordfile= SHARED
  service_names            = UBIX, bertruv
  job_queue_processes      = 5
  cursor_sharing           = SIMILAR
  max_dump_file_size       = 10240
  db_name                  = UBIX
  open_cursors             = 300
  ifile                    = c:\oracle\admin\UBIX\pfile\init.ora
  optimizer_index_cost_adj = 10
  optimizer_index_caching  = 95
  pga_aggregate_target     = 10737418240
  optimizer_dynamic_sampling= 2
PMON started with pid=2, OS id=332
PSP0 started with pid=3, OS id=336
MMAN started with pid=4, OS id=344
DBW0 started with pid=5, OS id=420
LGWR started with pid=6, OS id=424
CKPT started with pid=7, OS id=428
SMON started with pid=8, OS id=432
RECO started with pid=9, OS id=436
CJQ0 started with pid=10, OS id=440
MMON started with pid=11, OS id=444
MMNL started with pid=12, OS id=448
Fri May 22 09:33:38 2009
alter database mount exclusive
Fri May 22 09:33:43 2009
Setting recovery target incarnation to 1
Fri May 22 09:33:43 2009
Successful mount of redo thread 1, with mount id 1168818290
Fri May 22 09:33:43 2009
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Fri May 22 09:33:43 2009
alter database open
Fri May 22 09:33:44 2009
Beginning crash recovery of 1 threads
 parallel recovery started with 2 processes
Fri May 22 09:33:44 2009
Started redo scan
Fri May 22 09:33:45 2009
Completed redo scan
 435 redo blocks read, 42 data blocks need recovery
Fri May 22 09:33:45 2009
Started redo application at
 Thread 1: logseq 360, block 41072
Fri May 22 09:33:46 2009
Recovery of Online Redo Log: Thread 1 Group 3 Seq 360 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG3UBIX.LOG
Fri May 22 09:33:46 2009
Completed redo application
Fri May 22 09:33:46 2009
Completed crash recovery at
 Thread 1: logseq 360, block 41507, scn 779495593
 42 data blocks read, 36 data blocks written, 435 redo blocks read
Fri May 22 09:33:49 2009
Thread 1 advanced to log sequence 361
Thread 1 opened at log sequence 361
  Current log# 1 seq# 361 mem# 0: C:\ORACLE\ORADATA\UBIX\LOG1UBIX.LOG
Successful open of redo thread 1
Fri May 22 09:33:50 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri May 22 09:33:50 2009
SMON: enabling cache recovery
Fri May 22 09:33:54 2009
Successfully onlined Undo Tablespace 1.
Fri May 22 09:33:54 2009
SMON: enabling tx recovery
Fri May 22 09:33:54 2009
Database Characterset is WE8ISO8859P1
Fri May 22 09:33:55 2009
Errors in file c:\ora10\rdbms\trace\ubix_p001_1276.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
 
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=2156
Fri May 22 09:34:07 2009
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Fri May 22 09:34:15 2009
Errors in file c:\ora10\rdbms\trace\ubix_smon_432.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 09:34:20 2009
Doing block recovery for file 1 block 450437
Block recovery from logseq 361, block 327 to scn 779495649
Fri May 22 09:34:20 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 361 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG1UBIX.LOG
Block recovery completed at rba 361.610.0, scn 0.779495650
ORACLE Instance ubix (pid = 8) - Error 607 encountered while recovering transaction (7, 1) on object 47266.
Fri May 22 09:34:26 2009
Errors in file c:\ora10\rdbms\trace\ubix_smon_432.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 09:34:40 2009
Completed: alter database open
Fri May 22 09:41:09 2009
Errors in file c:\ora10\rdbms\trace\ubix_p001_3464.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 09:41:13 2009
Doing block recovery for file 1 block 450437
Block recovery from logseq 361, block 1432 to scn 779495920
Fri May 22 09:41:13 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 361 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG1UBIX.LOG
Block recovery stopped at EOT rba 361.1496.0
Block recovery completed at rba 361.1496.0, scn 0.779495918
Fri May 22 09:41:13 2009
SMON: Restarting fast_start parallel rollback
Fri May 22 09:41:15 2009
Errors in file c:\ora10\rdbms\trace\ubix_p000_2712.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 09:41:16 2009
Doing block recovery for file 1 block 450437
Block recovery from logseq 361, block 1432 to scn 779495920
Fri May 22 09:41:16 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 361 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG1UBIX.LOG
Block recovery completed at rba 361.1495.124, scn 0.779495921
Fri May 22 09:41:19 2009
SMON: ignoring slave err,downgrading to serial rollback
Fri May 22 09:41:20 2009
Errors in file c:\ora10\rdbms\trace\ubix_smon_432.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Doing block recovery for file 1 block 450437
Block recovery from logseq 361, block 1432 to scn 779495920
Fri May 22 09:41:21 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 361 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG1UBIX.LOG
Block recovery completed at rba 361.1495.124, scn 0.779495921
ORACLE Instance ubix (pid = 8) - Error 607 encountered while recovering transaction (7, 1) on object 47266.
Fri May 22 09:41:23 2009
Errors in file c:\ora10\rdbms\trace\ubix_smon_432.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Corrupt Block Found
         TSN = 0, TSNAME = SYSTEM
         RFN = 1, BLK = 450437, RDBA = 4644741
         OBJN = 47266, OBJD = 47266, OBJECT = SVCMON, SUBOBJECT = 
         SEGMENT OWNER = OPS$BRU, SEGMENT TYPE = Table Segment
Fri May 22 09:46:25 2009
Errors in file c:\ora10\rdbms\trace\ubix_p001_1976.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 09:46:28 2009
Doing block recovery for file 1 block 450437
Block recovery from logseq 361, block 1538 to scn 779496045
Fri May 22 09:46:28 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 361 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG1UBIX.LOG
Block recovery stopped at EOT rba 361.1541.0
Block recovery completed at rba 361.1541.0, scn 0.779496045
Fri May 22 09:46:28 2009
SMON: Restarting fast_start parallel rollback
Fri May 22 09:46:30 2009
Errors in file c:\ora10\rdbms\trace\ubix_p000_2324.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 09:46:31 2009
Doing block recovery for file 1 block 450437
Block recovery from logseq 361, block 1538 to scn 779496045
Fri May 22 09:46:31 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 361 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG1UBIX.LOG
Block recovery completed at rba 361.1540.280, scn 0.779496046
Fri May 22 09:46:34 2009
SMON: ignoring slave err,downgrading to serial rollback
Fri May 22 09:46:35 2009
Errors in file c:\ora10\rdbms\trace\ubix_smon_432.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Doing block recovery for file 1 block 450437
Block recovery from logseq 361, block 1538 to scn 779496045
Fri May 22 09:46:35 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 361 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG1UBIX.LOG
Block recovery completed at rba 361.1540.280, scn 0.779496046
ORACLE Instance ubix (pid = 8) - Error 607 encountered while recovering transaction (7, 1) on object 47266.
Fri May 22 09:46:38 2009
Errors in file c:\ora10\rdbms\trace\ubix_smon_432.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Corrupt Block Found
         TSN = 0, TSNAME = SYSTEM
         RFN = 1, BLK = 450437, RDBA = 4644741
         OBJN = 47266, OBJD = 47266, OBJECT = SVCMON, SUBOBJECT = 
         SEGMENT OWNER = OPS$BRU, SEGMENT TYPE = Table Segment
Fri May 22 09:51:40 2009
Errors in file c:\ora10\rdbms\trace\ubix_p001_2120.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 09:51:42 2009
Doing block recovery for file 1 block 450437
Block recovery from logseq 361, block 1580 to scn 779496169
Fri May 22 09:51:42 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 361 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG1UBIX.LOG
Block recovery stopped at EOT rba 361.1582.0
Block recovery completed at rba 361.1582.0, scn 0.779496169
Fri May 22 09:51:43 2009
SMON: Restarting fast_start parallel rollback
Fri May 22 09:51:44 2009
Errors in file c:\ora10\rdbms\trace\ubix_p000_2616.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 09:51:45 2009
Doing block recovery for file 1 block 450437
Block recovery from logseq 361, block 1580 to scn 779496169
Fri May 22 09:51:45 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 361 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG1UBIX.LOG
Block recovery completed at rba 361.1581.408, scn 0.779496170
Fri May 22 09:51:48 2009
SMON: ignoring slave err,downgrading to serial rollback
Fri May 22 09:51:49 2009
Errors in file c:\ora10\rdbms\trace\ubix_smon_432.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Doing block recovery for file 1 block 450437
Block recovery from logseq 361, block 1580 to scn 779496169
Fri May 22 09:51:49 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 361 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG1UBIX.LOG
Block recovery completed at rba 361.1581.408, scn 0.779496170
ORACLE Instance ubix (pid = 8) - Error 607 encountered while recovering transaction (7, 1) on object 47266.
Fri May 22 09:51:52 2009
Errors in file c:\ora10\rdbms\trace\ubix_smon_432.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Corrupt Block Found
         TSN = 0, TSNAME = SYSTEM
         RFN = 1, BLK = 450437, RDBA = 4644741
         OBJN = 47266, OBJD = 47266, OBJECT = SVCMON, SUBOBJECT = 
         SEGMENT OWNER = OPS$BRU, SEGMENT TYPE = Table Segment
Fri May 22 09:56:54 2009
Errors in file c:\ora10\rdbms\trace\ubix_p001_1852.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 09:56:57 2009
Doing block recovery for file 1 block 450437
Block recovery from logseq 361, block 1986 to scn 779496580
Fri May 22 09:56:57 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 361 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG1UBIX.LOG
Block recovery completed at rba 361.1991.0, scn 0.779496581
Fri May 22 09:56:58 2009
SMON: Restarting fast_start parallel rollback
Fri May 22 09:56:59 2009
Errors in file c:\ora10\rdbms\trace\ubix_p000_2112.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 09:57:00 2009
Doing block recovery for file 1 block 450437
Block recovery from logseq 361, block 1986 to scn 779496580
Fri May 22 09:57:00 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 361 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG1UBIX.LOG
Block recovery completed at rba 361.1990.432, scn 0.779496581
Fri May 22 09:57:03 2009
SMON: ignoring slave err,downgrading to serial rollback
Fri May 22 09:57:04 2009
Errors in file c:\ora10\rdbms\trace\ubix_smon_432.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 09:57:06 2009
Errors in file c:\ora10\rdbms\trace\ubix_pmon_332.trc:
ORA-00474: SMON process terminated with error
 
Fri May 22 09:57:06 2009
PMON: terminating instance due to error 474
Fri May 22 09:57:06 2009
Errors in file c:\ora10\rdbms\trace\ubix_q000_2556.trc:
ORA-00474: SMON process terminated with error
 
Fri May 22 09:57:06 2009
Errors in file c:\ora10\rdbms\trace\ubix_ckpt_428.trc:
ORA-00474: SMON process terminated with error
 
Fri May 22 09:57:07 2009
Errors in file c:\ora10\rdbms\trace\ubix_j001_2736.trc:
ORA-00474: SMON process terminated with error
 
Fri May 22 09:57:07 2009
Errors in file c:\ora10\rdbms\trace\ubix_mman_344.trc:
ORA-00474: SMON process terminated with error
 
Fri May 22 09:57:08 2009
Errors in file c:\ora10\rdbms\trace\ubix_reco_436.trc:
ORA-00474: SMON process terminated with error
 
Fri May 22 09:57:08 2009
Errors in file c:\ora10\rdbms\trace\ubix_dbw0_420.trc:
ORA-00474: SMON process terminated with error
 
Fri May 22 09:57:08 2009
Errors in file c:\ora10\rdbms\trace\ubix_psp0_336.trc:
ORA-00474: SMON process terminated with error
 
Fri May 22 09:57:08 2009
Errors in file c:\ora10\rdbms\trace\ubix_lgwr_424.trc:
ORA-00474: SMON process terminated with error
 
Instance terminated by PMON, pid = 332
Dump file c:\ora10\rdbms\trace\alert_ubix.log
Fri May 22 10:57:49 2009
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU                 : 2 - type 586, 2 Physical Cores
Process Affinity    : 0x00000000
Memory (Avail/Total): Ph:1436M/2046M, Ph+PgF:3482M/3939M, VA:1939M/2047M
Fri May 22 10:57:49 2009
Adjusting the default value of parameter parallel_max_servers
from 40 to 35 due to the value of parameter processes (50)
Fri May 22 10:57:49 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as C:\ora10\RDBMS
Autotune of undo retention is turned on. 
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.3.0.
System parameters with non-default values:
  processes                = 50
  timed_statistics         = TRUE
  shared_pool_size         = 83886080
  java_pool_size           = 4194304
  control_files            = C:\ORACLE\ORADATA\UBIX\CTL1UBIX.DBF, C:\ORACLE\ORADATA\UBIX\CTL2UBIX.DBF
  db_block_size            = 4096
  db_cache_size            = 54525952
  compatible               = 9.2.0.0.0
  log_buffer               = 23507968
  log_checkpoint_interval  = 10000
  db_files                 = 20
  db_file_multiblock_read_count= 32
  dml_locks                = 500
  undo_management          = AUTO
  undo_tablespace          = ROLLBACK
  remote_login_passwordfile= SHARED
  service_names            = UBIX, bertruv
  job_queue_processes      = 5
  cursor_sharing           = SIMILAR
  max_dump_file_size       = 10240
  db_name                  = UBIX
  open_cursors             = 300
  ifile                    = c:\oracle\admin\UBIX\pfile\init.ora
  optimizer_index_cost_adj = 10
  optimizer_index_caching  = 95
  pga_aggregate_target     = 10737418240
  optimizer_dynamic_sampling= 2
PMON started with pid=2, OS id=1300
PSP0 started with pid=3, OS id=1132
MMAN started with pid=4, OS id=2776
DBW0 started with pid=5, OS id=216
LGWR started with pid=6, OS id=2284
CKPT started with pid=7, OS id=3488
SMON started with pid=8, OS id=128
RECO started with pid=9, OS id=2568
CJQ0 started with pid=10, OS id=3296
MMON started with pid=11, OS id=1856
MMNL started with pid=12, OS id=436
Fri May 22 10:57:49 2009
alter database mount exclusive
Fri May 22 10:57:53 2009
Setting recovery target incarnation to 1
Fri May 22 10:57:53 2009
Successful mount of redo thread 1, with mount id 1168827437
Fri May 22 10:57:53 2009
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Fri May 22 10:57:53 2009
alter database open
Fri May 22 10:57:54 2009
Beginning crash recovery of 1 threads
 parallel recovery started with 2 processes
Fri May 22 10:57:54 2009
Started redo scan
Fri May 22 10:57:54 2009
Completed redo scan
 27 redo blocks read, 9 data blocks need recovery
Fri May 22 10:57:54 2009
Started redo application at
 Thread 1: logseq 361, block 1966
Fri May 22 10:57:54 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 361 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG1UBIX.LOG
Fri May 22 10:57:54 2009
Completed redo application
Fri May 22 10:57:54 2009
Completed crash recovery at
 Thread 1: logseq 361, block 1993, scn 779516584
 9 data blocks read, 9 data blocks written, 27 redo blocks read
Fri May 22 10:57:55 2009
Thread 1 advanced to log sequence 362
Thread 1 opened at log sequence 362
  Current log# 2 seq# 362 mem# 0: C:\ORACLE\ORADATA\UBIX\LOG2UBIX.LOG
Successful open of redo thread 1
Fri May 22 10:57:55 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri May 22 10:57:55 2009
SMON: enabling cache recovery
Fri May 22 10:57:56 2009
Successfully onlined Undo Tablespace 1.
Fri May 22 10:57:56 2009
SMON: enabling tx recovery
Fri May 22 10:57:56 2009
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=3024
Fri May 22 10:57:58 2009
Errors in file c:\ora10\rdbms\trace\ubix_p001_3148.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 10:58:01 2009
Doing block recovery for file 1 block 450437
Block recovery from logseq 362, block 62 to scn 779516664
Fri May 22 10:58:01 2009
Recovery of Online Redo Log: Thread 1 Group 2 Seq 362 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG2UBIX.LOG
Fri May 22 10:58:01 2009
Completed: alter database open
Fri May 22 10:58:01 2009
Block recovery stopped at EOT rba 362.69.0
Block recovery completed at rba 362.69.0, scn 0.779516663
Fri May 22 10:58:02 2009
SMON: Restarting fast_start parallel rollback
Fri May 22 10:58:03 2009
Errors in file c:\ora10\rdbms\trace\ubix_p000_2628.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 10:58:06 2009
Doing block recovery for file 1 block 450437
Block recovery from logseq 362, block 62 to scn 779516664
Fri May 22 10:58:06 2009
Recovery of Online Redo Log: Thread 1 Group 2 Seq 362 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG2UBIX.LOG
Block recovery completed at rba 362.68.320, scn 0.779516666
Fri May 22 10:58:08 2009
SMON: ignoring slave err,downgrading to serial rollback
Fri May 22 10:58:10 2009
Errors in file c:\ora10\rdbms\trace\ubix_smon_128.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Doing block recovery for file 1 block 450437
Block recovery from logseq 362, block 62 to scn 779516664
Fri May 22 10:58:12 2009
Recovery of Online Redo Log: Thread 1 Group 2 Seq 362 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG2UBIX.LOG
Block recovery completed at rba 362.68.320, scn 0.779516666
ORACLE Instance ubix (pid = 8) - Error 607 encountered while recovering transaction (7, 1) on object 47266.
Fri May 22 10:58:13 2009
Errors in file c:\ora10\rdbms\trace\ubix_smon_128.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 11:03:52 2009
Errors in file c:\ora10\rdbms\trace\ubix_p001_1164.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 11:03:54 2009
Doing block recovery for file 1 block 450437
Block recovery from logseq 362, block 92035 to scn 779575928
Fri May 22 11:03:55 2009
Recovery of Online Redo Log: Thread 1 Group 2 Seq 362 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG2UBIX.LOG
Block recovery completed at rba 362.92830.0, scn 0.779575929
Fri May 22 11:03:55 2009
SMON: Restarting fast_start parallel rollback
Fri May 22 11:03:58 2009
Errors in file c:\ora10\rdbms\trace\ubix_p000_3204.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 11:03:59 2009
Doing block recovery for file 1 block 450437
Block recovery from logseq 362, block 92035 to scn 779575928
Fri May 22 11:03:59 2009
Recovery of Online Redo Log: Thread 1 Group 2 Seq 362 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG2UBIX.LOG
Block recovery completed at rba 362.92829.248, scn 0.779575929
Fri May 22 11:04:01 2009
SMON: ignoring slave err,downgrading to serial rollback
Fri May 22 11:04:02 2009
Errors in file c:\ora10\rdbms\trace\ubix_smon_128.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Doing block recovery for file 1 block 450437
Block recovery from logseq 362, block 92035 to scn 779575928
Fri May 22 11:04:04 2009
Recovery of Online Redo Log: Thread 1 Group 2 Seq 362 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG2UBIX.LOG
Block recovery completed at rba 362.92829.248, scn 0.779575929
ORACLE Instance ubix (pid = 8) - Error 607 encountered while recovering transaction (7, 1) on object 47266.
Fri May 22 11:04:06 2009
Errors in file c:\ora10\rdbms\trace\ubix_smon_128.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Corrupt Block Found
         TSN = 0, TSNAME = SYSTEM
         RFN = 1, BLK = 450437, RDBA = 4644741
         OBJN = 47266, OBJD = 47266, OBJECT = SVCMON, SUBOBJECT = 
         SEGMENT OWNER = OPS$BRU, SEGMENT TYPE = Table Segment
Fri May 22 11:08:02 2009
Thread 1 advanced to log sequence 363
  Current log# 3 seq# 363 mem# 0: C:\ORACLE\ORADATA\UBIX\LOG3UBIX.LOG
Fri May 22 11:08:29 2009
Errors in file c:\ora10\rdbms\trace\ubix_p001_1164.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 11:08:33 2009
Doing block recovery for file 1 block 450437
Block recovery from logseq 363, block 1315 to scn 779614664
Fri May 22 11:08:33 2009
Recovery of Online Redo Log: Thread 1 Group 3 Seq 363 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG3UBIX.LOG
Block recovery completed at rba 363.1627.0, scn 0.779614665
Fri May 22 11:08:33 2009
SMON: Restarting fast_start parallel rollback
Fri May 22 11:08:36 2009
Errors in file c:\ora10\rdbms\trace\ubix_p000_3204.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 11:08:38 2009
Doing block recovery for file 1 block 450437
Block recovery from logseq 363, block 1315 to scn 779614664
Fri May 22 11:08:38 2009
Recovery of Online Redo Log: Thread 1 Group 3 Seq 363 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG3UBIX.LOG
Block recovery completed at rba 363.1626.200, scn 0.779614665
Fri May 22 11:08:42 2009
SMON: ignoring slave err,downgrading to serial rollback
Fri May 22 11:08:45 2009
Errors in file c:\ora10\rdbms\trace\ubix_smon_128.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Doing block recovery for file 1 block 450437
Block recovery from logseq 363, block 1315 to scn 779614664
Fri May 22 11:08:45 2009
Recovery of Online Redo Log: Thread 1 Group 3 Seq 363 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG3UBIX.LOG
Block recovery completed at rba 363.1626.200, scn 0.779614665
ORACLE Instance ubix (pid = 8) - Error 607 encountered while recovering transaction (7, 1) on object 47266.
Fri May 22 11:08:48 2009
Errors in file c:\ora10\rdbms\trace\ubix_smon_128.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Corrupt Block Found
         TSN = 0, TSNAME = SYSTEM
         RFN = 1, BLK = 450437, RDBA = 4644741
         OBJN = 47266, OBJD = 47266, OBJECT = SVCMON, SUBOBJECT = 
         SEGMENT OWNER = OPS$BRU, SEGMENT TYPE = Table Segment
Fri May 22 11:13:51 2009
Errors in file c:\ora10\rdbms\trace\ubix_p001_3268.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 11:13:54 2009
Doing block recovery for file 1 block 450437
Block recovery from logseq 363, block 2918 to scn 779614796
Fri May 22 11:13:54 2009
Recovery of Online Redo Log: Thread 1 Group 3 Seq 363 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG3UBIX.LOG
Block recovery stopped at EOT rba 363.2921.0
Block recovery completed at rba 363.2921.0, scn 0.779614795
Fri May 22 11:13:55 2009
SMON: Restarting fast_start parallel rollback
Fri May 22 11:13:57 2009
Errors in file c:\ora10\rdbms\trace\ubix_p000_2152.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Fri May 22 11:13:57 2009
Doing block recovery for file 1 block 450437
Block recovery from logseq 363, block 2918 to scn 779614796
Fri May 22 11:13:57 2009
Recovery of Online Redo Log: Thread 1 Group 3 Seq 363 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG3UBIX.LOG
Block recovery completed at rba 363.2919.500, scn 0.779614797
Fri May 22 11:14:00 2009
SMON: ignoring slave err,downgrading to serial rollback
Fri May 22 11:14:01 2009
Errors in file c:\ora10\rdbms\trace\ubix_smon_128.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Doing block recovery for file 1 block 450437
Block recovery from logseq 363, block 2918 to scn 779614796
Fri May 22 11:14:01 2009
Recovery of Online Redo Log: Thread 1 Group 3 Seq 363 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG3UBIX.LOG
Block recovery completed at rba 363.2919.500, scn 0.779614797
ORACLE Instance ubix (pid = 8) - Error 607 encountered while recovering transaction (7, 1) on object 47266.
Fri May 22 11:14:04 2009
Errors in file c:\ora10\rdbms\trace\ubix_smon_128.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []

En jetant un oeil sur metalink j'ai vu que ce bug est corrigé en 10.2.0.5.
Mais à quoi est dû ce bug?
qq'un a t'il une solution?
La base est une base 10.2.0.3

**mydb_server** · 27/05/2009, 10h33

Essaie de positionner le paramètre suivant :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

_in_memory_undo=FALSE

Rachid

**farenheiit** · 27/05/2009, 11h07

qu'est ce que c'est sensé faire?

**mydb_server** · 27/05/2009, 11h19

Apparemment ton problème est lié au Bug 5363584. La solution de détournement que propose Oracle est de positionner le dit paramètre à FALSE.

Je n'ai rien inventé moi

Rachid

**farenheiit** · 27/05/2009, 16h53

j'essaie d'effectuer la commande suivante mais ça ne marche pas:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

alter system set _in_memory_undo=FALSE

mais ça ne marche j'ai l'erreur suivante:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

ORa-00911: caractere non valide

D'ailleurs comment voir la valeur courante de ce paramètre? je ne le vois pas dans v$parameter

**fatsora** · 27/05/2009, 17h09

Dans ORA-00600 kddummy_blkchk si tu vas dans METALINK il y a plusieurs cas possibles de BUG ...

Comment peux tu etre sur que ce soit celui-la ... ??? : _in_memory_undo=FALSE

As tu setté le parametre db_block_checking ? (Condition du BUG au dessus !!)

As tu lu tous les fichiers *.trc générés ?

Que faisait exactement la base a ce moment la ?

Ta base demarre-elle ecnore normalement ou pas ?

Bref pour changer les parametres cachées et les affichier

http://arjudba.blogspot.com/2008/05/...le-how-to.html

**farenheiit** · 28/05/2009, 12h23

j'ai mis à jour le paramètre et j'ai toujours le même pb:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
Thu May 28 11:42:41 2009
Shutting down instance (abort)
License high water mark = 5
Instance terminated by USER, pid = 5940
Thu May 28 11:43:22 2009
Adjusting the default value of parameter parallel_max_servers
from 40 to 35 due to the value of parameter processes (50)
Thu May 28 11:43:22 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as C:\ora10\RDBMS
Autotune of undo retention is turned on. 
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.3.0.
System parameters with non-default values:
  processes                = 50
  timed_statistics         = TRUE
  shared_pool_size         = 83886080
  java_pool_size           = 4194304
  control_files            = C:\ORACLE\ORADATA\UBIX\CTL1UBIX.DBF, C:\ORACLE\ORADATA\UBIX\CTL2UBIX.DBF
  db_block_size            = 4096
  db_cache_size            = 54525952
  compatible               = 9.2.0.0.0
  log_buffer               = 23507968
  log_checkpoint_interval  = 10000
  db_files                 = 20
  db_file_multiblock_read_count= 32
  dml_locks                = 500
  undo_management          = AUTO
  undo_tablespace          = ROLLBACK
  remote_login_passwordfile= SHARED
  service_names            = UBIX, bertruv
  job_queue_processes      = 5
  cursor_sharing           = SIMILAR
  max_dump_file_size       = 10240
  db_name                  = UBIX
  open_cursors             = 300
  optimizer_index_cost_adj = 10
  optimizer_index_caching  = 95
  pga_aggregate_target     = 10737418240
  optimizer_dynamic_sampling= 2
PMON started with pid=2, OS id=5716
PSP0 started with pid=3, OS id=3064
MMAN started with pid=4, OS id=5904
DBW0 started with pid=5, OS id=4116
LGWR started with pid=6, OS id=248
CKPT started with pid=7, OS id=5232
SMON started with pid=8, OS id=5796
RECO started with pid=9, OS id=1256
CJQ0 started with pid=10, OS id=1596
MMON started with pid=11, OS id=4336
MMNL started with pid=12, OS id=2996
Thu May 28 11:45:16 2009
Shutting down instance: further logons disabled
Thu May 28 11:45:16 2009
Stopping background process CJQ0
Thu May 28 11:45:16 2009
Stopping background process MMNL
Thu May 28 11:45:17 2009
Stopping background process MMON
Thu May 28 11:45:17 2009
Shutting down instance (normal)
License high water mark = 1
Thu May 28 11:45:17 2009
Stopping Job queue slave processes
Thu May 28 11:45:17 2009
Job queue slave processes stopped
Thu May 28 11:45:17 2009
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thu May 28 11:47:27 2009
Adjusting the default value of parameter parallel_max_servers
from 40 to 35 due to the value of parameter processes (50)
Thu May 28 11:47:27 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as C:\ora10\RDBMS
Autotune of undo retention is turned on. 
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.3.0.
System parameters with non-default values:
  processes                = 50
  timed_statistics         = TRUE
  shared_pool_size         = 83886080
  java_pool_size           = 4194304
  control_files            = C:\ORACLE\ORADATA\UBIX\CTL1UBIX.DBF, C:\ORACLE\ORADATA\UBIX\CTL2UBIX.DBF
  db_block_size            = 4096
  db_cache_size            = 54525952
  compatible               = 9.2.0.0.0
  log_buffer               = 23507968
  log_checkpoint_interval  = 10000
  db_files                 = 20
  db_file_multiblock_read_count= 32
  dml_locks                = 500
  undo_management          = AUTO
  undo_tablespace          = ROLLBACK
  _in_memory_undo          = FALSE
  remote_login_passwordfile= SHARED
  service_names            = UBIX, bertruv
  job_queue_processes      = 5
  cursor_sharing           = SIMILAR
  max_dump_file_size       = 10240
  db_name                  = UBIX
  open_cursors             = 300
  optimizer_index_cost_adj = 10
  optimizer_index_caching  = 95
  pga_aggregate_target     = 10737418240
  optimizer_dynamic_sampling= 2
PMON started with pid=2, OS id=2848
PSP0 started with pid=3, OS id=2640
MMAN started with pid=4, OS id=6024
DBW0 started with pid=5, OS id=4980
LGWR started with pid=6, OS id=5208
CKPT started with pid=7, OS id=3816
SMON started with pid=8, OS id=4404
RECO started with pid=9, OS id=280
CJQ0 started with pid=10, OS id=4224
MMON started with pid=11, OS id=3904
MMNL started with pid=12, OS id=3872
Thu May 28 11:47:27 2009
ALTER DATABASE   MOUNT
Thu May 28 11:47:31 2009
Setting recovery target incarnation to 1
Thu May 28 11:47:31 2009
Successful mount of redo thread 1, with mount id 1169318607
Thu May 28 11:47:31 2009
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Thu May 28 11:47:31 2009
ALTER DATABASE OPEN
Thu May 28 11:47:31 2009
Beginning crash recovery of 1 threads
 parallel recovery started with 2 processes
Thu May 28 11:47:31 2009
Started redo scan
Thu May 28 11:47:32 2009
Completed redo scan
 1688 redo blocks read, 259 data blocks need recovery
Thu May 28 11:47:32 2009
Started redo application at
 Thread 1: logseq 380, block 3
Thu May 28 11:47:32 2009
Recovery of Online Redo Log: Thread 1 Group 2 Seq 380 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG2UBIX.LOG
Thu May 28 11:47:32 2009
Completed redo application
Thu May 28 11:47:32 2009
Completed crash recovery at
 Thread 1: logseq 380, block 1691, scn 780353473
 259 data blocks read, 259 data blocks written, 1688 redo blocks read
Thu May 28 11:47:33 2009
Thread 1 advanced to log sequence 381
Thread 1 opened at log sequence 381
  Current log# 3 seq# 381 mem# 0: C:\ORACLE\ORADATA\UBIX\LOG3UBIX.LOG
Successful open of redo thread 1
Thu May 28 11:47:33 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu May 28 11:47:33 2009
SMON: enabling cache recovery
Thu May 28 11:47:34 2009
Successfully onlined Undo Tablespace 1.
Thu May 28 11:47:34 2009
SMON: enabling tx recovery
Thu May 28 11:47:34 2009
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=3312
Thu May 28 11:47:36 2009
Errors in file c:\ora10\rdbms\trace\ubix_p001_4328.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Thu May 28 11:47:39 2009
Doing block recovery for file 1 block 450437
Block recovery from logseq 381, block 63 to scn 780353555
Thu May 28 11:47:39 2009
Recovery of Online Redo Log: Thread 1 Group 3 Seq 381 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG3UBIX.LOG
Thu May 28 11:47:39 2009
Completed: ALTER DATABASE OPEN
Thu May 28 11:47:39 2009
Block recovery stopped at EOT rba 381.71.0
Block recovery completed at rba 381.71.0, scn 0.780353554
Thu May 28 11:47:40 2009
SMON: Restarting fast_start parallel rollback
Thu May 28 11:47:42 2009
Errors in file c:\ora10\rdbms\trace\ubix_p000_4572.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Thu May 28 11:47:45 2009
Doing block recovery for file 1 block 450437
Block recovery from logseq 381, block 63 to scn 780353555
Thu May 28 11:47:45 2009
Recovery of Online Redo Log: Thread 1 Group 3 Seq 381 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG3UBIX.LOG
Block recovery completed at rba 381.70.316, scn 0.780353557
Thu May 28 11:47:46 2009
SMON: ignoring slave err,downgrading to serial rollback
Thu May 28 11:47:47 2009
Errors in file c:\ora10\rdbms\trace\ubix_smon_4404.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []
 
Doing block recovery for file 1 block 450437
Block recovery from logseq 381, block 63 to scn 780353555
Thu May 28 11:47:48 2009
Recovery of Online Redo Log: Thread 1 Group 3 Seq 381 Reading mem 0
  Mem# 0: C:\ORACLE\ORADATA\UBIX\LOG3UBIX.LOG
Block recovery completed at rba 381.70.316, scn 0.780353557
ORACLE Instance ubix (pid = 8) - Error 607 encountered while recovering transaction (7, 1) on object 47266.
Thu May 28 11:47:50 2009
Errors in file c:\ora10\rdbms\trace\ubix_smon_4404.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [450437], [6101], [], [], [], []

**farenheiit** · 28/05/2009, 12h29

Envoyé par fatsora

Dans ORA-00600 kddummy_blkchk si tu vas dans METALINK il y a plusieurs cas possibles de BUG ...

Comment peux tu etre sur que ce soit celui-la ... ??? : _in_memory_undo=FALSE

As tu setté le parametre db_block_checking ? (Condition du BUG au dessus !!)

As tu lu tous les fichiers *.trc générés ?

Que faisait exactement la base a ce moment la ?

Ta base demarre-elle ecnore normalement ou pas ?

Bref pour changer les parametres cachées et les affichier

http://arjudba.blogspot.com/2008/05/...le-how-to.html

Je n'ai pas touché au paramètre db_block_checking.
A quoi il sert?

**fatsora** · 28/05/2009, 15h40

DB_BLOCk_CHECKING

process serveur qui vérifie les blocks apres chaque operation DML

Je crois qu'il est temps de voir le support Oracle ....

de toute facon les parameters "_" il faut voir avec le support

Sinon si tu as mirroré tes fichiers de redolog , essayer de copier le mirroir sur le fichier endommagé.

ORA-00600: internal error code, arguments: [kddummy_blkchk]

Administration Oracle

Discussions similaires

Partager

Partager