Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  Data restore required from logical log

    Posted 07/09/26 05:20 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



    ------------------------------
    Khurram Shahzad
    ------------------------------


  • 2.  RE: Data restore required from logical log

    Posted 07/09/26 06:40 AM

    Khurram:

    You are not going to be able to restore just that missing partition (or even just that whole table) from the logs or archive to the source server. Your best bet will be to restore to another host and recover the table or just the missing data from there. First a question: are your archives taken using ontape or onbar?

    If onbar, then you just need to perform an export of the archive and logical log backups to the target host, then perform a point-in-time restore to before the 7:19 drop of the partition. 

    If ontape, it is both easier and harder. Just copy the latest archive and logical logs that followed it up until the last logical log back up file before 7:19 to the target host and perform a normal restore stopping after restoring that last logical log and bringing that server online.

    Either way, once the restored server is online, you should be able to export the missing data and insert it back into the original table after recreating the missing partition.

    There is one other options, but it is more involved. You could try using archecker to extract the table (or just the data from the dropped partition) from the archive. That can be restored to a new table in the same server, then you can copy the data to the original table from there or detach the dropped partition from the restored new table and attach it back to the original table.

    Art



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 3.  RE: Data restore required from logical log

    Posted 07/09/26 02:10 PM

    Hi Khurram.

    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.



    ------------------------------
    Doug Lawry
    Oninit Consulting
    ------------------------------