RMAN dump data file error ORA-19870 ORA-19502 ORA-27072"

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.