Restore Failed due to Corrupt Backup?
We suffered from a failure attempting to restore from a backup recently. Trying to restore (from two different backups) of our QA3 system resulted in the following error:
2012-02-15 17:16:06 4252 ERR 3 DBMKnl Received the result of an administrative statement from the database
4252 ERR 9 DBMKnl Statement: CREATE INSTANCE WITH RESTORE DATA FROM '/export/QA3/QA3_COM' FILE BLOCKSIZE 8 MEDIANAME 'FILE_DATA_BAK2'
4252 ERR 10 DBMKnl Returncode: -903
4252 ERR 5 DBMKnl Errortext: Host file I/O error
2012-02-15 17:16:06 4252 ERR -24580 DBMSrv ERR_COMMAND_FAILED: Command 'db_activate' has ended and failed with return code -24988.
4252 ERR -24988 DBMSrv ERR_SQL: SQL error
4252 ERR -24778 DBMSrv -903,Host file I/O error
4252 ERR -24778 DBMSrv 6,Data recovery failed
4252 ERR -24778 DBMSrv 11,The number of pages expected in the backup (40572007) does not match the number of pages actually recovered (40572003), 0 duplicate pages found in the backup
...the number of pages was slightly different on another attempt due to the different dates/sizes of the two backups we tried.
Has anyone seen this error before and/or know exactly what was wrong? We were restoring from an NFS mount, but a subsequent restore from a production backup using the exact same NFS mount worked fine (which points to the backup medium being corrupt rather than a problem with the NFS mount).
Let me know if any other logs are required to assist in diagnosis. I will also be logging a customer message regarding this.