2559289 - SAP IQ: Point-In-Time-Recovery with TIMESTAMP option doesn't work | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2559289 - SAP IQ: Point-In-Time-Recovery with TIMESTAMP option doesn't work

Symptom

SAP IQ Point-In-Time Recovery (PITR) with TIMESTAMP option is failing.

  • Restore SQL

       RESTORE DATABASE 'SAPIQDB' FROM '/iqbackup/.../backup.full.20171031_001'
       RECOVER UNTIL TIMESTAMP '2017-10-31 10:40:41.445'
       USING LOG PATH '/iqbackup/.../', '/iqbackup/IQ_LOGS/ARCHIVED/'
       OVERWRITE EXISTING CLEAR LOG ;

  • Error

      Catalog restore complete
      IQ file pre-allocation complete
      IQ data restore complete
      Could not execute statement.
      Unable to start specified database: Attempt to start recovery before first checkpoint of the backup
      SQLCODE=-82, ODBC 3 State="08001"

  • Other Error

Could not execute statement.
Run time SQL error -- Point-in-time recovery timeline branchpoint does not match beginning of log file
SQLCODE=-300, ODBC 3 State="HY000"
Line 1, column 1


Read more...

Environment

SAP IQ 16.0 SP11.x

Product

SAP IQ 16.0

Keywords

'PITR Restore' ; 'PITR TIMESTAMP' ; PITR TimeZone ; CR811718 ;  CR-811718 ; , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

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

Search for additional results

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