Table Restore
Posted in 1994
I have a question on recovery of a table in informix. We are using OnLine 4.10. The question is if one of your tables in your database was corrupted or dropped while transactions are being made against the database, how can the table be recovered from an archive lets say a level 0 and rolling forward the informix logs from tape without losing transactions against other tables in the database. I'm working on a customer site and I'm putting together disaster and recovery procedures and was asked this question by the customer. I have never faced this problem and could not think of a way to do a recovery of this type. I have done restores and rolled forward the transaction logs, but never had to exclude transaction from a log. Is it possible? Thanks Clyde H. Bryant