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

Onmiback.... Does that mean that you are using onbar to archive the server and ontape to archive the logical logs? What version of Informix are you on? Because IB that prior to 11.70 you cannot restore ontape log files with an onbar archive! Even in 11.70 it's a pain. 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:28 AM, Todd Roy <tmroy@hotmail.com> wrote: > > 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 > > >