ORA-19502: write error on file

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Oracle DBA

ORA-19502: write error on file

Error :
ORA-19502: write error on file
ORA-27072: File I/O error

Causes:
  • Disk space issue – The /u01/rman filesystem is full or near full.

  • Permission issue – The Oracle user (usually oracle) does not have write access to /u01/rman.

  • Filesystem limits – Hitting OS-level limits (max file size, ulimit restrictions).

  • Corrupted NFS mount – If /u01/rman is on NFS/ASM and there is a network/storage problem.

  • Disk errors – Underlying storage problem (bad sectors, I/O errors in dmesg).

Solution:
[root@node1 ~]# df -h /u01/rman/
Filesystem           Size  Used Avail Use% Mounted on
/dev/mapper/ol-root  106G  105G  725M 100% /

[root@node1 ~]# df -h /u01/rman/
Filesystem           Size  Used Avail Use% Mounted on
/dev/mapper/ol-root  106G  105G  725M 100% /
[root@node1 ~]#
[root@node1 ~]# find /u01/rman/ -name "*.bkp" -mtime +7 -delete
[root@node1 ~]# find /u01/rman/ -name "*PRIM_*" -mtime +3 -delete
[root@node1 ~]#
[root@node1 ~]# find /u01/rman/ -type f -exec du -h {} + | sort -rh | head -20
[root@node1 ~]# rm -f /u01/rman/old_large_backup_file1
[root@node1 ~]# rm -f /u01/rman/old_large_backup_file2
[root@node1 ~]#
[root@node1 ~]# df -h /u01/rman/
Filesystem           Size  Used Avail Use% Mounted on
/dev/mapper/ol-root  106G  101G  4.6G  96% /