Re: Informix Online Table Recovery: How?

Jon C Vemo (jvemo@cyberspace.com) wrote: : Depending on the size and the way the tables are laid out across = : dbspaces, an easier solution may exist. : In 7.x, dbspace level restore is supported through not only on-archive, = : but also ontape. If this may be useful, I suggest consulting TFM, in = : particular the "Archive and Backup Guide" Actually, I don't think this will work. As I recall, any dbspace-level restore requires that all logical logs be rolled forward. Assuming your database has logging, this will roll forward the deletion of the rows that you want to recover. If you are really lucky -- i.e. - your database is NOT logged, but - you DO back up your logical logs, and - all the rows you want were already in the database at the last archive then you can restore just one dbspace, roll it forward, and recover your lost data. June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Oakland ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.