oracle ora27072,ORACLE ORA-01110: ORA-27072: 处理

今天朋友的测试库报错， ORA-27072: File I/O error， Linux-x86_64 Error: 5: Input/output error，数据块已经不能正常启动，看到 Linux-x86_64 Error: 5: Input/output error多数是磁盘空间满导致的

KCF: read, write or open error, block=0x283980 >

file=5 ‘/app/oradata1/general_1.dbf’

error=27072 txt: ‘Linux-x86_64 Error: 5: Input/output error

Additional information: 4

Additional information: 2636160

Additional information: -1′

Errors in file /home/oracle/app/diag/rdbms/orcl/orcl/trace/orcl_dbw1_30299.trc:

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

ORA-01114: IO error writing block to file 5 (block # 2636160)

ORA-01110: data file 5: ‘/app/oradata1/general_1.dbf’

ORA-27072: File I/O error

Linux-x86_64 Error: 5: Input/output error

Additional information: 4

Additional information: 2636160

Additional information: -1

DBW1 (ospid: 30299): terminating the instance due to error 1242

Termination issued to instance processes. Waiting for the processes to exit

Instance terminated by DBW1, pid = 30299

查看磁盘使用情况，看空间还都比较富于，貌似不是空间引起的

[root@template app]# df -h

Filesystem            Size  Used Avail Use% Mounted on

/dev/vda3              16G   12G  3.5G  77% /

tmpfs                  32G   17G   15G  53% /dev/shm

/dev/vda1             194M   32M  153M  17% /boot

/dev/vdb1             2.0T  907G  963G  49% /app

查看主机是虚拟机还是物理机，发现是个虚拟机，如果是虚拟机的话可能出现存储超分的情况，(存储超分就是看着使用率可能不高但是实际上物理磁盘的空间可能已经满了)

[root@template app]# dmidecode |grep -i prod

Product Name: OpenStack Nova

删除了/app下的部分文件，如果删除部分文件能启动的话就是存储超分了

SQL> startup

ORACLE instance started.

Total System Global Area 2.6991E+10 bytes

Fixed Size                  2213976 bytes

<