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

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