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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.