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.
No comments:
Post a Comment
Thanks for reading till end. I hope this will help you more to improve your knowledge.
Now it's your turn!
What do you think? Share your experience in the comments box and subscribe for more interesting post.