Re: backing up logical logs to disk on Online, Ver. 5

At 10:42 PM 3/6/96 GMT, Marvin S Beck wrote: >The Online Ver. 5 Admin Guide indicates that logical logs can only be backed >up to tape and that continuous backups of the logs requires an attached >console. > > 1) tapes are slow and in this day of large 2 Gb and 4Gb disks, dynamic > backup to tape only seems very restrictive Yes. Just remember that Informix can only address 2GB of disk at a time. > 2) we do not have a monitor and keyboard on our server(s) (40-50 of them; > we use a remote console access to logon to the servers) Erk. I don't know of any way of circumventing this. However, if you're not doing continuous log backups, it shouldn't be a problem. > Is there any utility other than tbtape for backing up (and restoring) > logical logs? With V7, you have OnArchive. V5 only has tbtape. > Would tbtape work pointed at a raw disk device? (I doubt it since the > program appears to close, rewind and open the device--would disk > devices take such commands?) I don't see why not. I would, however, backup to a cooked disk file (with the appropriate permissions, etc.). Then backup the disk files to tape. > Is there any other way to backup logical logs--direct to tape is not > possible for us? > Is the only alternative to use (max) 60 log files and hope (:-)) they > don't all fill between system backups (= Informix archives?)? V7 also supports 32767 logs, not just 60 odd. > We are required by client software to use Online, ver. 5. I would hope > that Informix has advanced somewhat with later versions. Very much so. >We are planning on several Gbytes of data, some of it fairly active, so >we would anticipate the logs to fill quite quickly. Keep running frequent automatic backups. This will stop your logs from getting too full (provided you don't have long transactions, etc.) It appears that you are not aware of the difference between log backups and archives. RTFM, good luck, and have fun.... HTH. -- Cheers, Billy. ----------------------------------------------------------------------------- billy.wheeler@pixie.co.za +27 11 803 2151 p.o. box 3463, rivonia, rsa, 2128 +27 83 250 2324 "Have you got it yet?" (c) Kitsch 'n' Sync Productions 1996 -----------------------------------------------------------------------------