今天在扩容表空间的时候出现报错
ERROR at line 1:
ORA-19502: write error on file "/u01/app/oracle/oradata/gbps/LIS66.db", block number 1139968 (block size=8192)
ORA-27072: File I/O error
Additional information: 4
Additional information: 1139968
Additional information: 434176
查看alert告警日志中显示
alter tablespace LIS add datafile '/u01/app/oracle/oradata/gbps/LIS67.db' size 30G
Mon Dec 10 06:53:19 2018
ORA-19502 signalled during: alter tablespace LIS add datafile '/u01/app/oracle/oradata/gbps/LIS67.db' size 30G...
查看使用df -h查看磁盘空间已经剩余415M,磁盘空间不足导致报错。
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
30G 7.5G 21G 27% /
/dev/sda1 99M 13M 81M 14% /boot
tmpfs 7.9G 8.1M 7.9G 1% /dev/shm
/dev/mapper/datavg-lv_u01
3.9T 3.7T 415M 100% /u01
解决办法:只能和开发人员联系添加磁盘空间