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

We think the problem is the "L" flag in the informix properties of the destination of omniback has been set. Fortunately we have another small production database that we can test this with. the code in log_full.sh is: $BACKUP_CMD <<EOF 2>&1 >> /dev/null n EOF where BACKUP_CMD="ontape -a" Signature From: art.kagel@gmail.com Date: Thu, 15 Mar 2012 11:19:07 -0400 Subject: Re: Is there any way to rebackup a logical log that has been marked as backed up? To: tmroy@hotmail.com CC: marco@4glworks.com; informix-list@iiug.org That means the when someone runs ontape they are answering 'Y' when asked if they want to backup the current log. The answer should always be 'N'. The ALARMPROGRAM script/executable is run with event #23 passed in when the logical log changes and answering 'Y' to that question from ontape causes ontape to do the equivalent of running "onmode -l" which changes logs, so yes, the ALARMPROGRAM gets run with event #23, log completed. 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 11:04 AM, Todd Roy <tmroy@hotmail.com> wrote: I just looked at the omniback properties and it turns out that the two logical logs are being backed up to tape along with the dbspaces. I'm pretty sure that is NOT what we want to do. But log_full.sh is still being called! Signature From: tmroy@hotmail.com To: marco@4glworks.com; informix-list@iiug.org Subject: RE: Is there any way to rebackup a logical log that has been marked as backed up? Date: Thu, 15 Mar 2012 14:22:26 +0000 Well it normally takes a couple or three days for our logical logs to wrap and we L 0 nightly, the problem was the multiple logs that get created used and advanced during the backup process are the ones missing, because log_full.sh was being called repeatedly very rapidly. Signature > Date: Thu, 15 Mar 2012 14:15:14 +0000 > From: marco@4glworks.com > To: informix-list@iiug.org > Subject: Re: Is there any way to rebackup a logical log that has been marked as backed up? > > > > On 15/03/12 13:57, Todd Roy 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 > > > > Assuming that the logs haven't wrapped - the only way to achieve this is for > advanced support to dial in and remove the backed up flag from the logs you > are missing (Can be done, I have done it a few times). > I would suspect though that, unless you can provide a really robust business > need, tech support will just suggest that taking a whole L 0 will eliminate > the need to rearchive the missing logs. > > -- > Ciao, > Marco > ______________________________________________________________________________ > Marco Greco /UK /IBM Standard disclaimers apply! > > Structured Query Scripting Language http://www.4glworks.com/sqsl.htm > 4glworks http://www.4glworks.com > Informix on Linux http://www.4glworks.com/ifmxlinux.htm > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list