Re: Point in time recovery

In article <342EB5FA.5472@iiug.org>, June <junet@iiug.org> writes >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> > Glad to see your back! Where were you? and who wrote this utility? >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. -- David Williams