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.
SAP Knowledge Base Article - Preview