ORA-15080 ORA-27063报错
环境描述： hp unix 11.3 Oracle RAC 11.2.4.0
属于新库。调整相应表空间的大小。
ALTER TABLESPACE SYSAUX ADD datafile '+DATA_VOL/EPMFDP/DATAFILE/SYSAUX001.dbf' size 30G autoextend on
Wed Aug 26 16:20:23 2015
WARNING: Write Failed. group:2 disk:8 AU:4801 offset:0 size:1048576
Errors in file /u01/app/oracle/diag/rdbms/epmfdp/epmfdp2/trace/epmfdp2_ora_25628.trc:
ORA-15080: synchronous I/O operation to a disk failed
ORA-27063: number of bytes read/written is incorrect
HPUX-ia64 Error: 246: Operation would block
Additional information: -1
Additional information: 1048576
WARNING: failed to write mirror side 1 of virtual extent 4026 logical extent 0 of file 277 in group 2 on disk 8 allocation unit 4801
ORA-19502 signalled during: ALTER TABLESPACE SYSAUX ADD datafile '+DATA_VOL/EPMFDP/DATAFILE/SYSAUX001.dbf' size 30G autoextend on...
Wed Aug 26 16:29:45 2015
查看
/u01/app/oracle/diag/rdbms/epmfdp/epmfdp2/trace/epmfdp2_ora_25628.trc:
*** 2015-08-26 16:20:23.121
*** SESSION ID:(1712.101) 2015-08-26 16:20:23.121
*** CLIENT ID:() 2015-08-26 16:20:23.121
*** SERVICE NAME:(SYS$USERS) 2015-08-26 16:20:23.121
*** MODULE NAME:(sqlplus@jcsjdb02 (TNS V1-V3)) 2015-08-26 16:20:23.121
*** ACTION NAME:() 2015-08-26 16:20:23.121
WARNING: Write Failed. group:2 disk:8 AU:4801 offset:0 size:1048576
path:/dev/rdisk/disk67
incarnation:0xf0f01d3b asynchronous result:'I/O error'
subsys:System iop:0x9fffffffbf1822f0 bufp:0x9fffffffbef0fe00 osderr:0x0 osderr1:0x0
ORA-15080: synchronous I/O operation to a disk failed
ORA-27063: number of bytes read/written is incorrect
HPUX-ia64 Error: 246: Operation would block
Additional information: -1
Additional information: 1048576
WARNING: failed to write mirror side 1 of virtual extent 4026 logical extent 0 of file 277 in group 2 on disk 8 allocation unit 4801
WARNING: Write Failed. group:2 disk:6 AU:2293 offset:0 size:1048576
*** 2015-08-26 17:56:57.111
path:/dev/rdisk/disk63
incarnation:0xf0f01d3e asynchronous result:'I/O error'
subsys:System iop:0x9fffffffbf182468 bufp:0x9fffffffbe91fe00 osderr:0x0 osderr1:0x0
ORA-15080: synchronous I/O operation to a disk failed
ORA-27063: number of bytes read/written is incorrect
HPUX-ia64 Error: 11: Resource temporarily unavailable
Additional information: -1
Additional information: 1048576
WARNING: failed to write mirror side 1 of virtual extent 12162 logical extent 0 of file 276 in group 2 on disk 6 allocation unit 2293
初步看日志感觉是共享存储磁盘的问题。但是具体什么原因还是无法确定。
WARNING: failed to write mirror side 1 of virtual extent 4026 logical extent 0 of file 277 in group 2 on disk 8 allocation unit 4801
从这里看是对于你的asm的disk 8上面写的时候，出现异常，导致数据库无法写操作
建议看看asm日志和操作系统日志
页:
[1]