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% /