RE: Logical log restore

Almost anything is possible. See below for comments. The answers may vary depending upon which Informix backup tool (ontape, onarchive, onbar) is being used. -----Original Message----- From: Kudzi Muchaka [mailto:KMuchaka@HAFresno.org] Sent: Wednesday, August 16, 2000 10:44 To: informix-list@iiug.org Subject: Logical log restore >Greetings gurus, newbies, observers, spammers et al, > > Say I have Level 0 archives for Day 1, Day 2 and Day 3. I have logical logs for the 3 days as well. On Day 4 is it possible > to do a Level 0 restore for Day 1 and then a logical restore for Day 2, then try to do a logical restore for Day 3 while > bypassing Level 0 for Day 2. Should be possible. However, you would not want to do so unless the Day 2 backups were unreadable or unavailable. > Is it also possible to do Day 1 Level 0 restore and then Day 3 logical log restore, completely bypassing Day 2 Level 0 > archive and Day 2 logical logs. I am thinking something that would entail, maybe renumbering the log files. Hopefully, not. The purpose of the dbspace and logical log backups is to provide recoverability to a point in time. It is not intended to selectively replay some updates. Therefore, you must restore from dbspace backups and apply subsequent logical logs until you reach the desired stopping point. > hmmm... is this within the realms of possibility... Please don't ask me the whys of it all. I am more interested in the > possibilities or lack of of a work around. TIA -kudzi