SAP Knowledge Base Article - Preview

2498929 - Restore fails with 'Unable to read from archive' error

Symptom

When customer executes RESTORE DATABASE command they get the following messages displayed in the logs

Total number of IQ blocks being restored: 157128499
Total number of IQ blocks being restored: 157178524
Total number of IQ blocks being restored: 157228549
 Thrown from dblib/db_restore.cxx:503, Err# 202, tid 2 origtid 865
   O/S Err#: 0, ErrID: 4098 (db_sqlexception); SQLCode: -1012010, SQLState: 'QUA10', Severity: 14
[20933]: Unable to read from archive ('error reading from /orig/remotebu/disk_backups/IQBackups/ODW_full_backup_device03 ()').
-- (dblib/db_restore.cxx 503)
ValidateRestore
PrepareForRestore
DoRestore
Exception Thrown from dblib/db_restore.cxx:503, Err# 202, tid 879 origtid 879
   O/S Err#: 0, ErrID: 4098 (db_sqlexception); SQLCode: -1012010, SQLState: 'QUA10', Severity: 14
[20933]: Unable to read from archive ('error reading from /orig/remotebu/disk_backups/IQBackups/ODW_full_backup_device03 ()').
-- (dblib/db_restore.cxx 503)
Exception Thrown from dblib/db_restore.cxx:503, Err# 202, tid 2 origtid 879
   O/S Err#: 0, ErrID: 4098 (db_sqlexception); SQLCode: -1012010, SQLState: 'QUA10', Severity: 14
[20933]: Unable to read from archive ('error reading from /orig/remotebu/disk_backups/IQBackups/ODW_full_backup_device03 ()').
-- (dblib/db_restorTotal number of IQ blocks restored: 157242549  at 2017-07-04 10:21:35
    IQ blocksize = 8192
    backup blocksize = 8232
    blocking factor = 25
    buffersize = 205816


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

SYBASE, error , os log , raw device error , IQ , KBA , BC-SYB-IQ , Sybase IQ , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.