SOLVED

ORA-19502: write error on file

Asked by OracleDba••15 views•oracle
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
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).
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
[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% /
OracleDba•

Post Your Solution