Re: Is there any way to rebackup a logical log that has been marked as backed up?
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
>
>