“ oracle node 1, rac0101, has a disk HB, but no network HB, DHB has r cfg , wrtcnt ”
db突然停止运行
alert.log
Archived Log entry 52886 added for thread 2 sequence 27344 ID 0x980341ff dest 1:
Mon Jun 08 22:00:00 2015
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Mon Jun 08 22:00:00 2015
Starting background process VKRM
Mon Jun 08 22:00:00 2015
VKRM started with pid=291, OS id=21332
Tue Jun 09 00:11:51 2015
Thread 2 advanced to log sequence 27346 (LGWR switch)
Current log# 7 seq# 27346 mem# 0: +DATA/oradb/onlinelog/group_7.453.868440067
Current log# 7 seq# 27346 mem# 1: +DATA/oradb/onlinelog/group_7.457.868440069
Tue Jun 09 00:11:54 2015
Archived Log entry 52888 added for thread 2 sequence 27345 ID 0x980341ff dest 1:
Tue Jun 09 02:00:00 2015
Closing Resource Manager plan via scheduler window
Clearing Resource Manager plan via parameter
Tue Jun 09 12:08:08 2015
WARNING: db_recovery_file_dest is same as db_create_file_dest
Tue Jun 09 14:17:38 2015
NOTE: ASMB terminating
Errors in file /data/oracle/diag/rdbms/oradb/oradb2/trace/oradb2_asmb_25897.trc:
ORA-15064: ? ASM ??????
ORA-03113: ?????????
?? ID:
?? ID: 386 ???: 5
Errors in file /data/oracle/diag/rdbms/oradb/oradb2/trace/oradb2_asmb_25897.trc:
ORA-15064: ? ASM ??????
ORA-03113: ?????????
?? ID:
?? ID: 386 ???: 5
ASMB (ospid: 25897): terminating the instance due to error 15064
Instance terminated by ASMB, pid = 25897
Tue Jun 23 14:52:20 2015
alert_+ASM2.log
SQL> ALTER DISKGROUP ALL ENABLE VOLUME ALL /* asm agent *//* {0:8:9} */
SUCCESS: ALTER DISKGROUP ALL ENABLE VOLUME ALL /* asm agent *//* {0:8:9} */
Mon Jun 01 12:22:18 2015
WARNING: failed to online diskgroup resource ora.DATA.dg (unable to communicate with CRSD/OHASD)
Mon Jun 01 12:22:18 2015
NOTE: [crsd.bin@rac0102.tempus.cn (TNS V1-V3) 25061] opening OCR file
Starting background process ASMB
Mon Jun 01 12:22:18 2015
ASMB started with pid=25, OS id=25075
Mon Jun 01 12:22:18 2015
NOTE: client +ASM2:+ASM registered, osid 25077, mbr 0x0
Mon Jun 01 12:22:19 2015
NOTE: Attempting voting file refresh on diskgroup DATA
NOTE: Voting file relocation is required in diskgroup DATA
NOTE: Attempting voting file relocation on diskgroup DATA
Mon Jun 01 12:25:35 2015
ALTER SYSTEM SET local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.2.43)(PORT=1521))))' SCOPE=MEMORY SI
D='+ASM2';
Mon Jun 01 12:26:05 2015
NOTE: client oradb2:oradb registered, osid 25903, mbr 0x1
Tue Jun 09 14:17:38 2015
Tue Jun 09 14:17:38 2015
NOTE: client exited [25061]NOTE: ASMB process exiting, either shutdown is in progress
NOTE: or foreground connected to ASMB was killed.
Tue Jun 09 14:17:39 2015
Received an instance abort message from instance 1
Tue Jun 09 14:17:39 2015
Received an instance abort message from instance 1
Please check instance 1 alert and LMON trace files for detail.
Please check instance 1 alert and LMON trace files for detail.
opidcl aborting process unknown ospid (25073) as a result of ORA
db突然停止运行
alert.log
Archived Log entry 52886 added for thread 2 sequence 27344 ID 0x980341ff dest 1:
Mon Jun 08 22:00:00 2015
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Mon Jun 08 22:00:00 2015
Starting background process VKRM
Mon Jun 08 22:00:00 2015
VKRM started with pid=291, OS id=21332
Tue Jun 09 00:11:51 2015
Thread 2 advanced to log sequence 27346 (LGWR switch)
Current log# 7 seq# 27346 mem# 0: +DATA/oradb/onlinelog/group_7.453.868440067
Current log# 7 seq# 27346 mem# 1: +DATA/oradb/onlinelog/group_7.457.868440069
Tue Jun 09 00:11:54 2015
Archived Log entry 52888 added for thread 2 sequence 27345 ID 0x980341ff dest 1:
Tue Jun 09 02:00:00 2015
Closing Resource Manager plan via scheduler window
Clearing Resource Manager plan via parameter
Tue Jun 09 12:08:08 2015
WARNING: db_recovery_file_dest is same as db_create_file_dest
Tue Jun 09 14:17:38 2015
NOTE: ASMB terminating
Errors in file /data/oracle/diag/rdbms/oradb/oradb2/trace/oradb2_asmb_25897.trc:
ORA-15064: ? ASM ??????
ORA-03113: ?????????
?? ID:
?? ID: 386 ???: 5
Errors in file /data/oracle/diag/rdbms/oradb/oradb2/trace/oradb2_asmb_25897.trc:
ORA-15064: ? ASM ??????
ORA-03113: ?????????
?? ID:
?? ID: 386 ???: 5
ASMB (ospid: 25897): terminating the instance due to error 15064
Instance terminated by ASMB, pid = 25897
Tue Jun 23 14:52:20 2015
alert_+ASM2.log
SQL> ALTER DISKGROUP ALL ENABLE VOLUME ALL /* asm agent *//* {0:8:9} */
SUCCESS: ALTER DISKGROUP ALL ENABLE VOLUME ALL /* asm agent *//* {0:8:9} */
Mon Jun 01 12:22:18 2015
WARNING: failed to online diskgroup resource ora.DATA.dg (unable to communicate with CRSD/OHASD)
Mon Jun 01 12:22:18 2015
NOTE: [crsd.bin@rac0102.tempus.cn (TNS V1-V3) 25061] opening OCR file
Starting background process ASMB
Mon Jun 01 12:22:18 2015
ASMB started with pid=25, OS id=25075
Mon Jun 01 12:22:18 2015
NOTE: client +ASM2:+ASM registered, osid 25077, mbr 0x0
Mon Jun 01 12:22:19 2015
NOTE: Attempting voting file refresh on diskgroup DATA
NOTE: Voting file relocation is required in diskgroup DATA
NOTE: Attempting voting file relocation on diskgroup DATA
Mon Jun 01 12:25:35 2015
ALTER SYSTEM SET local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.2.43)(PORT=1521))))' SCOPE=MEMORY SI
D='+ASM2';
Mon Jun 01 12:26:05 2015
NOTE: client oradb2:oradb registered, osid 25903, mbr 0x1
Tue Jun 09 14:17:38 2015
Tue Jun 09 14:17:38 2015
NOTE: client exited [25061]NOTE: ASMB process exiting, either shutdown is in progress
NOTE: or foreground connected to ASMB was killed.
Tue Jun 09 14:17:39 2015
Received an instance abort message from instance 1
Tue Jun 09 14:17:39 2015
Received an instance abort message from instance 1
Please check instance 1 alert and LMON trace files for detail.
Please check instance 1 alert and LMON trace files for detail.
opidcl aborting process unknown ospid (25073) as a result of ORA