ORA-27072 instance crash

来源:互联网 发布:县令县丞县尉知具 编辑:程序博客网 时间:2024/06/06 07:27
一客户环境实例Crash
故障分析
告警日志报下列错误:
Wed May 22 20:44:56 2013ALTER SYSTEM SET local_listener=' (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxx)(PORT=1521))))' SCOPE=MEMORY SID='zjsggshx1';ALTER DATABASE MOUNT /* db agent *//* {0:4:6350} */This instance was first to mountNOTE: Loaded library: System SUCCESS: diskgroup DATA was mountedSUCCESS: diskgroup FLS was mountedNOTE: dependency between database zjsggshx and diskgroup resource ora.DATA.dg is establishedNOTE: dependency between database zjsggshx and diskgroup resource ora.FLS.dg is establishedErrors in file /u01/app/oracle/diag/rdbms/zjsggshx/zjsggshx1/trace/zjsggshx1_ora_5440222.trc:ORA-27072: File I/O errorIBM AIX RISC System/6000 Error: 16: Device busyAdditional information: 7Additional information: 26656Additional information: -1WARNING: Read Failed. group:1 disk:5 AU:13 offset:16384 size:16384WARNING: failed to read mirror side 1 of virtual extent 5 logical extent 0 of file 256 in group [1.2296563320] from disk DATA_0005  allocation unit 13 reason error; if possible, will try another mirror sideErrors in file /u01/app/oracle/diag/rdbms/zjsggshx/zjsggshx1/trace/zjsggshx1_ora_5440222.trc:ORA-00202: control file: '+DATA/zjsggshx/controlfile/current.256.814874815'ORA-15081: failed to submit an I/O operation to a diskORA-204 signalled during: ALTER DATABASE MOUNT /* db agent *//* {0:4:6350} */...Wed May 22 20:45:01 2013Reconfiguration started (old inc 2, new inc 4)List of instances: 1 2 (myinst: 1)  Global Resource Directory frozen Communication channels reestablished Master broadcasted resource hash value bitmaps Non-local Process blocks cleaned outWed May 22 20:45:01 2013 LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survivedWed May 22 20:45:01 2013 LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived Set master node info  Submitted all remote-enqueue requests Dwn-cvts replayed, VALBLKs dubious All grantable enqueues granted Post SMON to start 1st pass IR Submitted all GCS remote-cache requests Post SMON to start 1st pass IR Fix write in gcs resourcesReconfiguration completeWed May 22 20:45:03 2013Shutting down instance (abort)License high water mark = 1USER (ospid: 18284702): terminating the instanceInstance terminated by USER, pid = 18284702Wed May 22 20:45:05 2013




操作系统日志:
LABEL:          SC_DISK_ERR10IDENTIFIER:     65DE6DE3Date/Time:       Wed May 22 20:45:00 CST 2013Sequence Number: 5128Machine Id:      00F7E1D44C00Node Id:         zjsggsdb_01Class:           SType:            PERMWPAR:            GlobalResource Name:   hdisk5          DescriptionREQUESTED OPERATION CANNOT BE PERFORMEDProbable CausesDASD DEVICEUser CausesRESOURCE NOT AVAILABLEUNAUTHORIZED ACCESS ATTEMPTEDRecommended ActionsFOR REMOVABLE MEDIA, CHANGE MEDIA AND RETRYPERFORM PROBLEM DETERMINATION PROCEDURESFailure CausesMEDIADISK DRIVERecommended ActionsFOR REMOVABLE MEDIA, CHANGE MEDIA AND RETRYPERFORM PROBLEM DETERMINATION PROCEDURESDetail DataPATH ID           2SENSE DATA0A00 2800 0000 6820 0000 2004 0000 0000 0000 0000 0000 0000 0118 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 14C6 000A E280 0000 0000 0000 0000 0000 0000 0000 0003 0000 0000 003D 0017 ---------------------------------------------------------------------------


解决方案
从错误日志来看是hdisk5故障导致,硬件厂家未检查出错误,为不影响系统运行,暂时的解决办法是从asm中删除磁盘hdisk5,再进行观察。
原创粉丝点击