SAPIQ PITR fals

Hi guys,

I am not able to restore SAPIQ to a specific point in time.

The restore from FULL or INCREMENTAL backup works well.

Follows the last lines of PITR restore (it seems to be able to recover but something at the end fails ):

...

179716:recover: Coordinating all the child recovery processes.

179717:recover: Releasing all the resources held by the recovery process.

179721:recover: All recovery streams from the NetWorker server 'nw16sv01.bnl.cos.lan' are read successfully.

Received 13 file(s) from NSR server `nw16sv01.bnl.cos.lan'

Recover completion time: Thu 11 Sep 2025 11:23:13 AM CEST

09/11/25 11:23:13.228413 recover-D1 Total file count                        :13

09/11/25 11:23:13.228438 recover-D1 Total files recovered successfully:     :13

09/11/25 11:23:13.228460 recover-D1 Total files recovered unsuccessfully:   :0

09/11/25 11:23:13.228470 recover-D1 Total files remaining to be recovered:  :0

09/11/25 11:23:13.228480 recover-D1 Total calculated:                       :13

09/11/25 11:23:13.228490 recover-D1 Unneeded files and directory listings are discarded but included in the "remaining to be recovered" file count.

179068:recover: Step (8 of 8) for PID-762: The recovery completed successfully on the client 'sapd69.ess.pnad.pninfrasrv.net'.

09/11/25 11:23:13.281271 recover-D1 Updating the Total Recover size: 1625806897 and Total Files: 13 to jobdb

09/11/25 11:23:13.299848 recover-D1 calling clntnsr_end_2_2

09/11/25 11:23:13.303657 recover-D1 nsr_end cs_nfiles =0, cs_size = 0

09/11/25 11:23:13.303915 recover-D1 DDCL cleanup start.

09/11/25 11:23:13.304293 recover-D1 DDCL cleanup end.

mv: cannot stat '/usr/sap/DIQ/SIQ00/siqdata/log/temp/log/*': No such file or directory

mv: cannot stat '/usr/sap/DIQ/SIQ00/siqdata/log/temp/LogArchive/*': No such file or directory

********

Recovery for database 'DIQ' will recover the 'full' level backup performed at UTC time Tue Sep  9 12:59:47 2025

********

170519:nsriqrc: Received an error from the server ''. Error code: 13435. Severity: 16. State: 0.

       SQL Anywhere Error -1079: Backup is unable to open database file '/usr/sap/DIQ/SIQ00/siqdata/log/DIQ.log'186360:nsriqrc: Unable to recover one of the transaction log backups of database 'DIQ'.

171290:nsriqrc: Unable to restore database 'DIQ'.

..

Could you please help with this ? 

i think the following could be the real issue :

mv: cannot stat '/usr/sap/DIQ/SIQ00/siqdata/log/temp/log/*': No such file or directory

mv: cannot stat '/usr/sap/DIQ/SIQ00/siqdata/log/temp/LogArchive/*': No such file or directory

 

under /usr/sap/DIQ/SIQ000/sigdata/log/temp there isn't log or logarchive directory , there is ../sigadata/log/...

Thank you 

Nicola