Saturday, October 11, 2014

Oracle Error ORA-19502: write error on file

Problem:
You are getting ORA-19502 during RMAN backup or add file file/logfile command.

Error message:
SQLPLUS> alter database add logfile group 1 ('/data/test/redo01.log') size 50M;
alter database add logfile group 1 ('/oraredo/cs9tmp/redo04.log') size 50M
*
ERROR at line 1:
ORA-19502: write error on file "/data/test/redo01.log", block number 3002369 (block size=512)
ORA-27072: File I/O error
Additional information: 4
Additional information: 3002369
Additional information: 568832


Solution:

Options to resolve:

1. Clean up unnecessary files under /data/test/*

2. Add disk space to /data/test/*

3. Specify different mount point or drive letter “/newData/test/*

Then re-run your command.





I hope this helps.

Please feel free to leave your questions or suggest improvements to this section.

No comments:

Post a Comment