ORA-27072、ORA-27072错误解析

ORA-27072、ORA-27072共同出现，一般是由于空间不足引起。

情况描述

SQL> alter database add logfile group 7 '/data1/ray/redo07.log' size 2G;
alter database add logfile group 7 '/data1/ray/redo07.log' size 2G
*
ERROR at line 1:
ORA-19502: write error on file "/data1/ray/redo07.log", blockno 970753
(blocksize=512)
ORA-27072: File I/O error
Linux-x86_64 Error: 9: Bad file descriptor
Additional information: 4
Additional information: 970753
Additional information: 282112

查看操作系统空间

[oracle@ray DP]$ df -Th
Filesystem           Type   Size  Used Avail Use% Mounted on
/dev/mapper/vg_centos-lv_root
                     ext4    50G  5.1G   42G  11% /
tmpfs                tmpfs   16G   72K   16G   1% /dev/shm
/dev/sda1            ext4   477M   94M  358M  21% /boot
/dev/mapper/vg_centos-lv_home
                     ext4    34G  123M   32G   1% /home
/dev/sdb1            ext4    50G   15G   32G  33% /oracle
/dev/sdb2            ext4   296G  280G  492M 100% /data1
/dev/sdb3            ext4   148G   97G   44G  70% /data2
/dev/sdc1            ext4   197G   52G  136G  28% /data3
/dev/sdb4            ext4   516G  442G   49G  91% /archived

扩容空间后，问题解决。