Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Restore Failed due to Corrupt Backup?

Hi,

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.

Thanks,

Chaz.

Former Member
Not what you were looking for? View more on this topic or Ask a question