Re: Selective Data Restore (?)

Richard, I haven't done much research on this, but I think you'll have a problem if you tried to restore to a separate OnLine instance running on the same machine. The first things copied to an archive are the system reserved pages from the root dbspace. These would include references to the chunk paths which shouldn't be duplicated between instances of OnLine. OnLine will check for overlapped chunks within the same instance, but will not check for overlapping between different instances. In article 1BE@informatik.uni-muenchen.de, spitz@GAN03X (Richard Spitz) writes: >Ken Miles (kenm@vcd.hp.com) wrote: > >: Now I'm up against Informix' tbtape facility which "cannot restore a >: selected table or database. . . OnLine restores the complete contents >: of those tapes, which include all OnLine databases." (P. 4-33, OnLine >: Admin. Guide). I also have an around the clock production shop and have >: limited opportunity to perturb the users of those other databases. > >Can you install a second ONLINE server on another (or even the same) machine? >You could then restore your archive to that other server, then >unload the data you deleted and load these data into your original data- >base. > >I know this is pretty tedious, but it should work and not disrupt your >production database. > >Hope it helps, >Richard >-- >+----------------------------+-------------------------------------------+ >| Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | >| EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 | >| Klinikum Grosshadern | FAX : +49-89-7095-8886 | >| Munich, Germany | | >+----------------------------+-------------------------------------------+ Regards, Bob Colombo # Std. disclaimers apply.