Re: Restoring archive without logical logs

gosport <gosport@pobox.oleane.net> wrote: >Does anyone know how to restore a level 0 archive without the logical >logs and without patching the rootdbs ??? >We had this problem on our HP9000 K200 running DSA 7.12, and we tortured >the engineer from Informix until he patched the rootdbs so that we could >go on-line without restoring the logical logs (we hadn't saved'em all >the way). >Note that there is no mention about the 'compulsarity' of continuously >saving the logical logs in the DSA administrator guide... >Valery FOUQUES, GOSPORT, FRANCE On several occasions I have had the opportunity to restore a 7.11 version of informix with ontape and not restore the logs. However, I have also tried to restore one dbspace with ontape and you then must roll foward the logs. Ontape backs up the entire system and it is documented that you can do a partial restore down to the dpspace level, but it also stats if you do a partial you must roll foward your logs. If you do a full recovery of the entire system with ontape you do not have to roll foward your logs. When we attempted the partial restore without restore the logs the online would not come up. This is well documented in the backup and recovery guide. -- Tolly Brumbelow, Informix DBA email:tolly.brumbelow@bridge.bellsouth.com