新增檔案的時候報錯：ORA-19502 block number 2050049 (block size=512): ORA-27072:

SQL> alter database add logfile group 2 ('/u01/app/oracle/oradata/VIPBIEDW/redo02a.log','/u01/app/oracle/oradata/VIPBIEDW/redo02b.log') size 1G
*
ERROR at line 1:
ORA-19502: write error on file "/u01/app/oracle/oradata/VIPBIEDW/redo02a.log", block number 2050049 (block size=512)
ORA-27072: File I/O error
Additional information: 4
Additional information: 2050049
Additional information: 339456

u01下的磁碟空間滿了
[oracle@BIDB ~]$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda3              50G   20G   28G  42% /
tmpfs                  64G   31G   33G  50% /dev/shm
/dev/sda1             291M   36M  240M  14% /boot
/dev/sda4              30G  173M   28G   1% /tmp
/dev/sda5              47G   44G  3.6M 100% /u01
/dev/sda6             1.1T   58G  993G   6% /u02
/dev/sda7             842G  201M  799G   1% /orabak
[oracle@BIDB ~]$ cd /u01/app/oracle/oradata/VIPBIEDW/

問題知道了，就很容易處理了！