Re: backing up more then one instance

Art S. Kagel wrote: > > wrobelc@belnet.bellevue.k12.wa.us wrote: > > > > Our environment is HP/UX 10.20 running Informix 7.23. We have two DB > > instances. I want to do a non-interactive backup of both instances > > but when using 'ontape' with only one tape drive this is not possible. > > Can anyone tell me how I can accomplish a non-interactive backup of > > the two db instances to one tape? Additionally, how would a restore > > be done? > > You cannot do this. You can backup both to the same drive > consecutively, obviously, but you have to change tapes in between. > > You could use a no-rewind device and consecutively write the second > archive to the second file on the tape but ontape will not be able to > restore the second archive since it rewinds the tape twice during the > restore. You would have to manually copy the file off of the tape to > another device. Not fun and I've never tried this myself. > > Art S. Kagel I want to do this as well, with v7.13 on Solaris. My best solution so far is to use ontape for the larger instance, and onarchive to disk for the smaller. I already append Solaris ufsdumps to a single ontape archive without problems. I'm going to try Art's suggestion. What utility is suggested to copy the second ontape archive onto disk or another tape? dd? Neil Truby Chase Manhattan Bank Bournemouth, UK neil.truby@chase.com