RE: Is there any way to rebackup a logical log that has been marked as backed up?

Art, 11.50FC5. I do have LTAPEDEV set, so you are telling me that I don't have to worry about multiple execution. We think that what is happening is that we have a setting wrong in omniback (somewhere) that is backing up the logical logs to disk along with the dbspaces, but log_full.sh is still being kicked off. I like your log_full.sh versus alarmprogram.sh because its simple and concise. Thanks, Todd. Signature From: art.kagel@gmail.com Date: Thu, 15 Mar 2012 10:58:25 -0400 Subject: Re: Is there any way to rebackup a logical log that has been marked as backed up? To: tmroy@hotmail.com CC: informix-list@iiug.org No, but what version of Informix are you running? If you are running 11.10 or later you can set LTAPEDEV to the directory name and ontape will take care of renaming the log archive files and of preventing multiple copies of ontape from running out of the ALARMPROGRAM. Then you can use the alarmprogram.sh that IBM delivers in $INFORMIXDIR/etc/ just change BACKUP_CMD to 'ontape -a -d' and BACKUPLOGS to 'Y'. Also, note that using a version of my log_full.ksh if there are multiple logical log files full at the time the script gets kicked off (usually because a previous run failed for space or something) or if another log fills while ontape is still running, the log archive file may contain multiple logs and there will appear to be a gap in the file name numbering which will look like a log archive file is missing, but all is well. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Mar 15, 2012 at 9:57 AM, Todd Roy <tmroy@hotmail.com> wrote: We've been backing up logical logs to disk for some months using a modified version of Art Kagel's log_full.sh command. Its been going well, but I noticed that sometimes, if logical logs get marked as complete fast enough, some of the logs seem to drop into the bit bucket rather than go to disk. This may be due to my compressing the logical log in the script and somehow multiple copies of log_full.sh running simultaneously. I've fixed the problem by adding a lock file, but I appear to have missing backups. Any way to reback these up? Thanks in advance, Todd