The following error occurs when rman is used for restore:
Channel c1: ORA-19870: error while restoring backup piece/u01/dbfull_03orat5q_1_1.bak
ORA-19502: write error on file "/u01/app/Oracle/oradata/aux/system01.dbf", block number 34304 (block size = 8192)
ORA-27072: File I/O error.
An error occurred while writing the file. For more information, see:
Oerr ora 19502.
19502,000 00, "write error on file \" % s \ ", block number % s (block size = % s )"
// * Cause: write error on output file
// * Action: check the file
This prompt tells us to check the file. Is the file wrong.
Oerr ora 19870.
19870,000 00, "error while restoring backup piece % s"
// * Cause: This error shocould be followed by other errors indicating
// The cause of the problem.
// * Action: See other errors actions.
This prompt shows other error messages.
Oerr ora 27072.
27072,000 00, "File I/O error"
// * Cause: read/write/readv/writev system call returned error, additional
// Information indicates starting block number of I/O
// * Action: check errno
This prompt has no value.
Finally, view the disk space as follows:
Df-h
Filesystem Size Used Avail Use % Mounted on
/Dev/sda1 5.7 GB 3.1G 2.4G 57%/
/Dev/sdb1 20G 19G 269 M 99%/u01
Tmpfs 1.5G 265 M 1.3G 18%/dev/shm
The disk space is insufficient. After some disk space is released, the problem is solved. Record it here.
Recommended reading:
ORA-01172, ORA-01151 error handling
ORA-00600 [2662] troubleshooting
Troubleshooting for ORA-01078 and LRM-00109
Notes on ORA-00471 Processing Methods
ORA-00314, redolog corruption, or missing Handling Methods
Solution to ORA-00257 archive logs being too large to store