SAP Knowledge Base Article - Preview

3200513 - Cannot restore PITR to the latest offset/timestamp - SAP IQ

Symptom

Cannot restore PITR (Point in Time Recovery) to the latest offset/timestamp

  1. 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;

  2. 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.