Re: How to continue log backups automatically?

On 17 Jun 1997, Ofer Inbar wrote: > Informix OnLine DS 7.22.UC2 on HP-UX 10.20 > > I'd like to run continuous log backups from the console, all the > time. I'm not on site every day, but the operators on site know how > to look at the console and mount new tapes when requested. This is a good thing. > However, there are database users here who sometimes have legitimate > reasons to take Informix briefly offline. I've written a simple > script for them that will also bring the ON-Archive cataloger down, > and then restart it when they restart the server. But the continuous > log backup dies and does not restart. I'd be interested, from a curiosity standpoint, to find out what those reasons are. > Is there any way I can... > - Make the log backup survive an Informix restart? Hrm. No, not really. > - Re-start the continuous log backup from my script, but have it run > *on the console* even though users run the script from telnet sessions? Well, run a script on the console that will restart continuous logging whenever it recieves a signal ... something along those lines could be done. > - Have the continous log backup restart itself on the console > periodically, if it's not already running (either via cron or some > ON-Archive feature I haven't absorbed from the manual yet)? This could fall into the above, or you could always use the log-full-alert script (forget the name) that Informix kindly runs when a log is full. > Any one of these three would solve my problem, and there may be other > possibilities I haven't thought of. And at least one problem -- you can't run logging again without changing the tape. For that reason, something that ejects the current tape and spawns continuous logging might be best, then your operators wouldn't be overwriting log tapes. -Richard