Introduction:- In this article, we will resolve the ORA 19502 write error.In logs showing as RMAN abort with ORA-19502: write error on file and ORA-27072: File I/O error.
Below error coming while trying to restore the oracle database using RMAN backup.
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00090 to /data01/PROD/datafiles/a_txn_ind23.dbf
channel ORA_DISK_1: reading from backup piece /backup/rmanPROD/Wednesday_03_03_2021_00:25:01/DB_1_20210303_53253.rbkp
channel ORA_DISK_1: ORA-19870: error while restoring backup piece /rmanbkp/rmanPROD/Wednesday/DB_1_20210303_53253.rbkp
ORA-19502: write error on file “/data01/PROD/datafiles/a_txn_ind23.dbf”, block number 3718144 (block size=8192)
ORA-27072: File I/O error
Additional information: 4
Additional information: 3718144
Additional information: 921600
Error from RMAN session:-
ORA-19502: write error on file “/data01/PROD/datafiles/a_txn_ind23.dbf”, block number 3718144 (block size=8192)
ORA-27072: File I/O error
Solution:-
This usually means there is not sufficient enough disk space for the backup. The most likely cause of this error is that no enough disk space for the RMAN datafiles restoration.
To resolve this error , you need to remove unwanted/unnecessary file from from file system or add disk space or change the another datafile location to restore the complete database or datafiles.