Symptom
Cannot restore PITR (Point in Time Recovery) to the latest offset/timestamp
- Restore full backup
restore database '/SYBASE/IQ/IQ-16_1/demo/iqdemo.db'
from '/SYBASE/IQ/IQ-16_1/demo/mybackup/full.bck'
overwrite existing clear log; - Restore incremental since full backup and PITR up to the latest offset/timestamp
restore database '/SYBASE/IQ/IQ-16_1/demo/iqdemo.db'
from '/SYBASE/IQ/IQ-16_1/demo/mybackup/incsf.bck'
recover until offset 1561331 -- latest offset
using log path '/SYBASE/IQ/IQ-16_1/demo/pitrLogBackup'
,'/SYBASE/IQ/IQ-16_1/demo/mybackup'
,'/SYBASE/IQ/IQ-16_1/demo' ;
Could not execute statement.
Restore Internal Error.
-- (dblib/db_backupCmds.cxx 5376)
SQLCODE=-1012022, ODBC 3 State="HY000"
Line 1, column 1
Read more...
Environment
SAP IQ 16.1 SP05
Keywords
826546, CR#826546 CR826546, PITR, "incremental since full" , KBA , BC-SYB-IQ , Sybase IQ , Known Error
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.