ORA-19502, ORA-27072 during RMAN restore (Oracle)

Uncategorized , , 3 Comments

I was trying to load database from an RMAN backup (duplicate database until …), and the restore process died after some time, and gave me the following error messages (I have tried it several times, with different backups, these repeated randomly):

ORA-19502: write error on file "/path/to/datafile.dbf", blockno 1669073 (blocksize=8192)
ORA-27072: File I/O error
Linux Error: 2: No such file or directory

ORA-19502: write error on file "/path/to/datafile.dbf", blockno 1831475 (blocksize=8192)
ORA-27072: File I/O error
Linux Error: 13: Permission denied

Long story short, these messages are exotic forms of the boring “Out of disk space” message.

And even if you have enough space for the restore, you may need ~+20% spare space. Don’t know exactly why, but that was needed in my case.

Oracle loves disk space and strange messages – lesson learned.

3 thoughts on “ORA-19502, ORA-27072 during RMAN restore (Oracle)

  • ohchely

    This worked out for me. Increased the space and rectified the error. Of course followed by some other errors which in-turn rectified 🙂

    Thank You

  • Walter

    Thanks!! You are right, Oracle loves stranges messages to say something simple like that.

  • neda

    thank you so much 🙂 it works for me ..

Leave a Reply

Your email address will not be published. Required fields are marked *