添加文件的时候报错：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/
问题知道了，就很容易处理了！
*
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/
问题知道了，就很容易处理了！
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30936525/viewspace-2016695/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
