Hi , I am having release Release 11.2.0.3.0 of oracle. Got database crash tuesday morning, and i am trying to get the reason for the crash. Given below is the alert.log for same. I can see Process RSM0 is getting killed , triggered the crash but could not relate it to the event follwed.
--------------------------------- ALERT.LOG---------------------------
Tue Aug 13 00:20:51 2013
Thread 1 advanced to log sequence 9737 (LGWR switch)
Current log# 3 seq# 9737 mem# 0: +DATA01/sid1004/onlinelog/group_3.379.817601969
Current log# 3 seq# 9737 mem# 1: +DATA02/sid1004/onlinelog/group_3.5858.817601983
Tue Aug 13 00:20:51 2013
LNS: Standby redo logfile selected for thread 1 sequence 9737 for destination LOG_ARCHIVE_DEST_2
Tue Aug 13 00:21:11 2013
Archived Log entry 20595 added for thread 1 sequence 9736 ID 0xe56c03af dest 1:
Tue Aug 13 00:30:48 2013
Thread 1 advanced to log sequence 9738 (LGWR switch)
Current log# 4 seq# 9738 mem# 0: +DATA01/sid1004/onlinelog/group_4.378.817601995
Current log# 4 seq# 9738 mem# 1: +DATA02/sid1004/onlinelog/group_4.7210.817602007
Tue Aug 13 00:30:48 2013
LNS: Standby redo logfile selected for thread 1 sequence 9738 for destination LOG_ARCHIVE_DEST_2
Tue Aug 13 00:30:55 2013
Archived Log entry 20597 added for thread 1 sequence 9737 ID 0xe56c03af dest 1:
Tue Aug 13 00:40:41 2013
Thread 1 advanced to log sequence 9739 (LGWR switch)
Current log# 5 seq# 9739 mem# 0: +DATA01/sid1004/onlinelog/group_5.377.817602019
Current log# 5 seq# 9739 mem# 1: +DATA02/sid1004/onlinelog/group_5.10031.817602031
Tue Aug 13 00:40:42 2013
LNS: Standby redo logfile selected for thread 1 sequence 9739 for destination LOG_ARCHIVE_DEST_2
Tue Aug 13 00:40:47 2013
Archived Log entry 20599 added for thread 1 sequence 9738 ID 0xe56c03af dest 1:
Tue Aug 13 00:50:41 2013
Thread 1 advanced to log sequence 9740 (LGWR switch)
Current log# 6 seq# 9740 mem# 0: +DATA01/sid1004/onlinelog/group_6.376.817602043
Current log# 6 seq# 9740 mem# 1: +DATA02/sid1004/onlinelog/group_6.6026.817602057
Tue Aug 13 00:50:41 2013
LNS: Standby redo logfile selected for thread 1 sequence 9740 for destination LOG_ARCHIVE_DEST_2
Tue Aug 13 00:50:46 2013
Archived Log entry 20601 added for thread 1 sequence 9739 ID 0xe56c03af dest 1:
Tue Aug 13 01:00:40 2013
Thread 1 advanced to log sequence 9741 (LGWR switch)
Current log# 7 seq# 9741 mem# 0: +DATA01/sid1004/onlinelog/group_7.375.817602069
Current log# 7 seq# 9741 mem# 1: +DATA02/sid1004/onlinelog/group_7.10703.817602081
Tue Aug 13 01:00:41 2013
LNS: Standby redo logfile selected for thread 1 sequence 9741 for destination LOG_ARCHIVE_DEST_2
Tue Aug 13 01:00:46 2013
Archived Log entry 20603 added for thread 1 sequence 9740 ID 0xe56c03af dest 1:
Tue Aug 13 01:09:02 2013
minact-scn: useg scan erroring out with error e:12751
Tue Aug 13 01:10:38 2013
Thread 1 advanced to log sequence 9742 (LGWR switch)
Current log# 8 seq# 9742 mem# 0: +DATA01/sid1004/onlinelog/group_8.374.817602093
Current log# 8 seq# 9742 mem# 1: +DATA02/sid1004/onlinelog/group_8.12060.817602105
Tue Aug 13 01:10:39 2013
LNS: Standby redo logfile selected for thread 1 sequence 9742 for destination LOG_ARCHIVE_DEST_2
Tue Aug 13 01:10:51 2013
Archived Log entry 20605 added for thread 1 sequence 9741 ID 0xe56c03af dest 1:
Tue Aug 13 01:15:55 2013
Time drift detected. Please check VKTM trace file for more details.
Tue Aug 13 01:16:27 2013
Thread 1 advanced to log sequence 9743 (LGWR switch)
Current log# 1 seq# 9743 mem# 0: +DATA01/sid1004/onlinelog/group_1.381.817601921
Current log# 1 seq# 9743 mem# 1: +DATA02/sid1004/onlinelog/group_1.5144.817601933
Tue Aug 13 01:17:51 2013
Process RSM0, PID = 8562, will be killed
Tue Aug 13 02:19:38 2013
Starting ORACLE instance (normal)