ORA-27072 instance crash
来源:互联网 发布:县令县丞县尉知具 编辑:程序博客网 时间:2024/06/06 07:27
一客户环境实例Crash
故障分析
告警日志报下列错误:
操作系统日志:
解决方案
从错误日志来看是hdisk5故障导致,硬件厂家未检查出错误,为不影响系统运行,暂时的解决办法是从asm中删除磁盘hdisk5,再进行观察。
故障分析
告警日志报下列错误:
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,再进行观察。
- ORA-27072 instance crash
- ORA-00227, ORA-00202: BRING UP INSTANCE AFTER MACHINE CRASH [ID 1072762.6]
- RAC Instance Crash with ORA-600: [Kjbmprlst:Shadow] (Doc ID 740028.1)
- 【ORA-600】[kcratr_nab_less_than_odr] 异常宕机后的实例恢复during Instance Recovery after Database Crash
- ORA-00494: enqueue [CF] held for too long (more than 900 seconds) cause instance crash
- ORA-600 [KFDAUDEALLOC2] AND INSTANCE CRASH EVEN WITH THE FIX OF BUG 14467061 (文档 ID 1903273.1)
- ORA-01624: log 3 needed for crash recovery of instance orcl (thread 1)
- Bug2108072导致Instance Crash
- Instance Crash & Bug 13846531
- BUG 10008092 caused instance crash
- ORA-24550 Crash in RandomCycler
- database crash with ora-00494
- ORA-01092:ORACLE instance terminated. Disconection forced
- ORA-15064: communication failure with ASM instance
- ORA-00265: instance re…
- ORA-01092: ORACLE instance terminated. Disconnection forced
- How to release IPC resource after oracle Instance crash/abort
- 小萝莉说Crash(一):Unrecognized selector sent to instance xxxx
- MySQL Workbench: mysqldump version mismatch
- C++21点纸牌游戏
- SDUT OJ 树-堆结构练习——合并果子之哈夫曼树 C++优先队列练习
- silverlight+WCF的net.tcp双工通信实例过程
- JAVA SSH 框架介绍
- ORA-27072 instance crash
- 主成分分析和核函数
- source insight中添加.S文件
- JAVA垃圾回收器
- fedora 18 jdk7的安装与配置
- lib和dll关系与区别/使用方法
- C宏定义的简单总结——转
- 详谈 UNIX 环境进程异常退出
- 远程安装实施时,如何配置远程服务器的本地 yum 安装源