3657218 - SAP IQ database fails to start up with "Failed to open PITR log" after restoring on another host

Symptom

SAP IQ database fails to start up with "Failed to open PITR log" after restoring on another host

Error: Failed to open PITR log /PITR_LOG/SAPIQ.log_XXX_XXXXXX_XXXX_XXXXXXXX_XXXXXXXXXXXX.iqlog for logging.
-- (stcxtlib/st_database.cxx 9702)
E. 09/09 04:41:05.247383 Failed to open PITR log /PITR_LOG/SAPIQ.log_XXX_XXXXXX_XXXX_XXXXXXXX_XXXXXXXXXXXX.iqlog for logging.
-- (stcxtlib/st_database.cxx 9702)
I. 09/09 04:41:05.247430 Database server shutdown due to startup error
Failed to open PITR log /PITR_LOG/SAPIQ.log_XXX_XXXXXX_XXXX_XXXXXXXX_XXXXXXXXXXXX.iqlog for logging.
-- (stcxtlib/st_database.cxx 9702)
Database server shutdown due to startup error
I. 09/09 04:41:05.248391 Completing server shutdown

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

sybase iq, database startup error, failed to open PITR log, PITR log missing, point-in-time recovery, sybase iq restore, database server shutdown, -fp parameter, reset PITR, SAP IQ troubleshooting , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.