RE: ontape restore problem

Sorry for using HTML in the original post... The problem disappeared, after I filled the problematic chunk with zeroes before the restore. I don't think this is a good workaround - just because it takes a lot of extra time to fill ALL chunks with zeroes. I've filed a bug to PA ' ------------------------------------------ Alexey Sonkin ' ________________________________________ From: Alexey Sonkin [mailto:alexeis@grandvirtual.com] Hi, everybody, I've just run into a very strange issue with ontape restore. We have a staging system, onto which we restore our production 'ontape' backup from time to time, so that QA team could test applications in environment close to the production. Yesterday, after the restore, it appeared that one of most active tables is corrupt with it's indexes. The same table was not corrupt in the production database. Investigation revealed, that table corruption was caused by the presence of records, that were added to the table by the QA team before the restore. That is, during the restore, table pages allocated to the table during the previous QA cycle, were mysteriously mixed with pages restored from the archive. Is it a known issue? Is it fixed in 9.40? P.S. A saw very similar problem in the past with ONBAR restore: if server is restored into the same chunks where Informix instance was working before, logical restore might try to use traces of logical log remaining from the previous life... ------------------------------------------ Alexey Sonkin ' sending to informix-list