Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Restore database fail with ORA-19501

Hello,
I'm trying to restore my DB from full cold backup, but it fails with this error.
ORA-19870: error while restoring backup piece /mnt/new/ORACLE_20191123_s3347_s27
ORA-19501: read error on file "/mnt/new/ORACLE_20191123_s3347_s27", block number 57088 (block size=8192)
ORA-27072: File I/O error
Additional information: 4
Additional information: 57088
Additional information: 802816
I googled a lot but all info for ORA-19502, not ORA-19501
any advice
Thanks in advance.
Answers
-
ORA-19870: error while restoring backup piece /mnt/new/ORACLE_20191123_s3347_s27ORA-19501: read error on file "/mnt/new/ORACLE_20191123_s3347_s27", block number 57088 (block size=8192)ORA-27072: File I/O error
ORA errors can give you a clue, but will not necessarily tell you the solution.
What is /mnt/new?
How was the cold backup performed?
It that a NFS share? There could be various problem related to networking or NFS.
The file could also be corrupt.
Is the problem occurring right when the restore starts, or in the middle?
You need to provide info about your setup or installation for anyone to be able to help you.
-
Can you please provide more details about your environment & "/mnt/new/"?
Kindly check if your "/mnt" is mounted correctly as per Oracle recommendations given below;
Mount Options for Oracle files for RAC databases and Clusterware when used with NFS on NAS devices (Doc ID 359515.1)
Regards,
Adi