Re: How to Restore a unique table from an ontape archive

Bob < wrote: > Hi, > > I used the simpliest solution, i restored on another computer and using > unload/load restored my data, i also found the archecker utility but was not > able to found adequate documentation to use it. Will try anyway to make > further research on this archecker thingy and post here the result if > successfull. > > Thanks for your time. > > Fred > > "Martin Fuerderer" <MARTINFU@de.ibm.com> a 'crit dans le message de news: > 1125512810.d88d51fb5420b71d33142a2b653143e3@teranews... > >>Hi, >> >>hmm, not really. >>Just restoring a dbspace will be a warm restore, however, a warm >>restore always has to include complete logical recovery, so that >>the restored dbspace will be consistent with the rest of dbspaces >>(that were not restored). This logical log restore phase will of >>course apply the erroneous delete as well, so after the restore >>the desired data will again (or still) be missing. >> >>Depending on dbspace layout of the system, it may be an option >>to restore into a second (new) instance only the critical dbspaces >>(root dbspace and dbspaces containing logical and physical log), >>plus the dbspace containing the database in question. If that does >>not contain the table in question, then that dbspace also needs to >>be restored. All other dbspaces need not be restored (maybe you >>need to think about whether the table in question has BLOB-space >>BLOBs, so that BLOB-space would also need to be restored). >>With that "minimal" restore you should be able to extract the data >>from the table ("UNLOAD TO ..."). >>Keep in mind that you should not restore all the logs - you need to >>stop logical restore before you reach the log file that contains the >>erroneous delete. With ON-Bar you can do Point-In-Time restore. >>With ontape you can only stop log restore after each logical log >>tape (i.e. no better granularity). >> >>In some versions (even older ones) there was somehow an >>undocumented procedure to extract data from an archive using >>archecker. I don't know exactly how that works, and therefore >>I can't say whether it ever was possible on Windows (a system >>that doesn't have the concept of pipes ?). If you think that this >>is the only hope left, then I advice you to open a call with >>IBM Informix Technical Support. They will be able to tell you if >>and possibly how to do this. >> >>Regards, >>Martin >>-- >>Martin Fuerderer >>IBM Informix Development Munich, Germany >>Information Management >> >>owner-informix-list@iiug.org wrote on 31.08.2005 12:33:37: >> >>>Do you have everyone table stored in a different dbspace? >>> >>>if yes then you can just restore that dbspace >>> >>>if not then your option will be to restore the archive to a speerate >>>machine/instance and then unload the table your require >>> >>>Bob wrote: >>> >>>>Hi all, >>>> >>>>I made an error and deleted some row in a table, restoring all the >> >>database >> >>>>from my ontape archive is not a valid solution and i must find a way >> >>to >> >>>>restore this only table. Is there any solution ? >>>> >>>>My system is IDS 7.31 Workgroup edition running on Win 2000 (sp4) >>>> >>>>Any help would be appreciated :-) >>>> >>>>Fred >> >>sending to informix-list > > > On 10.00 this funcionality is fully supported and should be completly documented. In previous versions it was neither of this... and I personaly never got it to work when I needed... Got it in test however... but it had too many limitations (and bugs...). Regards.