ORA-19502: write error on file "xxxxx", block number xxxx

ORA-19502: write error on file "xxxxx", block number xxxx

在ORACLE 11g下执行下述命令

1、创建数据文件

CREATE TABLESPACE OAPF_ITRAVEL_DATA LOGGING DATAFILE '/data/oracle/oradata/tablespace/oapf_itravel_data.dbf'
SIZE 500M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
Extent Management Local Segment Space Management Auto;

 

错误提示：

ERROR at line 1:
ORA-19502: write error on file
"/data/oracle/oradata/tablespace/oapf_itravel_data.dbf", block number 7808
(block size=8192)
ORA-27072: File I/O error
Additional information: 4
Additional information: 7808
Additional information: 532480

 

错误原因：

 

从报错信息来看应该是写文件时遇到I/O错误，一般是磁盘空间不足导致。用df命令查看磁盘空间

联系DBA,检查下数据库是否开启归档，检查归档的文件

归档路径：/data/oracle/oraarch,定期清理归档文件

 

常用查询语句

--阻塞会话
select /*+ rule */ * from v$session a where sid in(select distinct sid from v$lock b where block=1);
--被阻塞会话
select * from v$session where blocking_session is not null;