Informix

 View Only

 Partial data restore from logical log.

Muhammad Abrar's profile image
Muhammad Abrar posted 07/09/26 05:15 AM

During activity we have mistakenly drop a partition .
Now we want to restore data from logical log partially
Kindly guide how we can perform this task.

logical log backup is taken at 07:10 (388030) and next backup is take at 07:20 (388031)
partition detach and drop time is 07:19
we need to restore partial data from log id 388031

we are using ontape for backup .
we are using 14.10FC11X7

Doug Lawry's profile image
Doug Lawry IBM Champions

Hi Muhammad.

It seems that Khurram has already asked this in another thread.

You can use this to extract a point-in-time copy of a table:
https://www.oninitgroup.com/faq-items/informix-table-restore

Afterwards, you can copy back the rows you lost.