Problem Diagnosis - Expert Oracle RAC Performance Diagnostics and Tuning - page 631

Fri Dec 17 18:07:06 2010
Instance recovery: looking for dead threads
Submitted all GCS remote-cache requests
Post SMON to start 1st pass IR
Fix write in gcs resources
Reconfiguration complete
Beginning instance recovery of 1 threads
parallel recovery started with 23 processes
Started redo scan
Completed redo scan
read 1670 KB redo, 628 data blocks need recovery
Started redo application at
Thread 1: logseq 6, block 35939
Recovery of Online Redo Log: Thread 1 Group 5 Seq 6 Reading mem 0
Mem# 0: +PRD_DATA/prddb/onlinelog/group_5.263.737994533
Mem# 1: +PRD_FRA/prddb/onlinelog/group_5.259.737994535
Fri Dec 17 18:07:09 2010
minact-scn: Inst 2 is now the master inc#:8 mmon proc-id:20073 status:0x7
minact-scn status: grec-scn:0x0000.00000000 gmin-scn:0x0000.00108c8e gcalc-scn:0x0000.00108c99
minact-scn: master found reconf/inst-rec before recscn scan old-inc#:8 new-inc#:8
Completed redo application of 1.52MB
Completed instance recovery at
Thread 1: logseq 6, block 39279, scn 1105982
604 data blocks read, 610 data blocks written, 1670 redo k-bytes read
Thread 1 advanced to log sequence 7 (thread recovery)
minact-scn: master continuing after IR
Fri Dec 17 18:07:33 2010
Dumping diagnostic data in directory=[cdmp_20101217180733], requested by (instance=1, osid=20398
(ASMB)), summary=[abnormal instance termination].
Fri Dec 17 18:07:58 2010
Reconfiguration started (old inc 8, new inc 10)
List of instances:
1 2 (myinst: 2)
Global Resource Directory frozen
Communication channels reestablished
When the instance is released from the freeze, it joins the cluster immediately.
Critical ORA Errors
DBAs, when paged for critical production issues and the message received on the page/e-mail/notification is an
ORA-0600 error, will allmost always get on the the database server to get an understanding of how critical or what
kind of immediate impact it has on the system and then starts working on creating a support request (SR) with Oracle
support. In this section, we discuss two important such errors: ORA-0600 and ORA-7445.
ORA-600: Internal error code, arguments: [...], [...]
An ORA-600 error indicates a kernel exception. When such an error is encountered, Oracle records certain details
related to this error in the alert log file and also in a trace file.