ORA-27072 instance crash

最新推荐文章于 2022-10-02 12:03:57 发布

songyb

最新推荐文章于 2022-10-02 12:03:57 发布

阅读量2.8k

点赞数

分类专栏： Troubleshoot 文章标签： Instance Crash ORA-27072 故障数据库

本文链接：https://blog.csdn.net/songyongbo_107/article/details/9199341

版权

Troubleshoot 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

一客户环境实例Crash
故障分析
告警日志报下列错误：

Wed May 22 20:44:56 2013
ALTER 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 mount
NOTE: Loaded library: System 
SUCCESS: diskgroup DATA was mounted
SUCCESS: diskgroup FLS was mounted
NOTE: dependency between database zjsggshx and diskgroup resource ora.DATA.dg is established
NOTE: dependency between database zjsggshx and diskgroup resource ora.FLS.dg is established
Errors in file /u01/app/oracle/diag/rdbms/zjsggshx/zjsggshx1/trace/zjsggshx1_ora_5440222.trc:
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 16: Device busy
Additional information: 7
Additional information: 26656
Additional information: -1
WARNING: Read Failed. group:1 disk:5 AU:13 offset:16384 size:16384
WARNING: 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 side
Errors 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 disk
ORA-204 signalled during: ALTER DATABASE MOUNT /* db agent *//* {0:4:6350} */...
Wed May 22 20:45:01 2013
Reconfiguration 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 out
Wed May 22 20:45:01 2013
 LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Wed 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 resources
Reconfiguration complete
Wed May 22 20:45:03 2013
Shutting down instance (abort)
License high water mark = 1
USER (ospid: 18284702): terminating the instance
Instance terminated by USER, pid = 18284702
Wed May 22 20:45:05 2013

操作系统日志：

LABEL:          SC_DISK_ERR10
IDENTIFIER:     65DE6DE3


Date/Time:       Wed May 22 20:45:00 CST 2013
Sequence Number: 5128
Machine Id:      00F7E1D44C00
Node Id:         zjsggsdb_01
Class:           S
Type:            PERM
WPAR:            Global
Resource Name:   hdisk5          


Description
REQUESTED OPERATION CANNOT BE PERFORMED


Probable Causes
DASD DEVICE


User Causes
RESOURCE NOT AVAILABLE
UNAUTHORIZED ACCESS ATTEMPTED


	Recommended Actions
	FOR REMOVABLE MEDIA, CHANGE MEDIA AND RETRY
	PERFORM PROBLEM DETERMINATION PROCEDURES


Failure Causes
MEDIA
DISK DRIVE


	Recommended Actions
	FOR REMOVABLE MEDIA, CHANGE MEDIA AND RETRY
	PERFORM PROBLEM DETERMINATION PROCEDURES


Detail Data
PATH ID
           2
SENSE DATA
0A00 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，再进行观察。