Re: Point in time recovery

What support told you IS correct, because in order to restore just a single dbspace, you must roll forward the logical logs up to the current log. That will result in rolling forward all the bad SQL commands that scrogged up their database in the first place. Unless your database has no logging, in which case nothing will roll forward, and your database will be in the same state it was when the archive was taken. This (no logging) will sort of simulate a rough form of point-in-time recovery on a dbspace level IF you can stand to turn off logging (a very big IF). Otherwise, for just this sort of emergency (Nils :) I have put on the IIUG website a utility which (hopefully) will simulate a tbunload/onunload of a single table from a tbtape/ontape (ooops, I think you said you were using onbar, and it doesn't support onbar) level-0 archive. Please note that this utility is designed for EMERGENCIES, and should NEVER be used as part of your normal backup/recovery strategy, as it is in no way guaranteed to work in all instances. It hasn't even been thoroughly tested, but I decided that it couldn't really wait until I had enough time and energy to do all that testing myself (who knows when THAT would be). Please read all the warnings (and there are a lot :) before you attempt to use it. It is ABSOLUTELY NOT SUPPORTED by Informix (note my userid :) or by the IIUG (read all the IIUG legal mumbo-jumbo about nothing having any warranties, implied or express). Consider this (very) beta software. June <Standard disclaimers apply several times over> Rs wrote: > > I am not sure if what the support tell you is correct. If you > do 'onbar --', it allows you to backup and restore dbspaces as > an entity itself. I have tried that myself, and it worked.