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

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@terane ws...
>
> 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

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@terane ws...
>
>>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.