ADSM-L

Re: DB backup doesn't decrease recovery log utilization

1999-08-27 03:30:11
Subject: Re: DB backup doesn't decrease recovery log utilization
From: "Mauro M. TINELLI" <Mauro.TINELLI AT ST DOT COM>
Date: Fri, 27 Aug 1999 09:30:11 +0200
Steffan,

        you're trying to scare me, aren't you! Well you succeed.
What about 4096 MB? will they be all right?

Mauro, STM

> Mauro,
>
> Just a tip: reduce your log back down to 4GB or so.  At 5GB should you
> run into a problem your only resort will be to restore the database
from
> the last backup.
>
> Steffan
>
> "Mauro M. TINELLI" wrote:
> >
> > Gerhard,
> >
> >         I had a exactly the same problem. Once, it happened at night
when I'm
> > running all the back-ups, so the system after rescheduling 4 times a
DB
> > Backup, closed itself up, and the next morning I had to add some log
> > space in order to restart the server.
> >
> >         The log was about 1 Gbyte in size ... now is 5 Gbytes and the
> > DbBackupTrigger is at 55%. It never happened again! he maximum I
reached
> > is 75% of log in use. Is it a workaround? I don't know, but it fixed
the
> > problem.
> >
> > PS. IBM said the problem was known. But they asked me to lower the
DBB
> > threshold and it didn't work.
> >
> > Mauro, STM
> >
> > > Hello,
> > > since yesterday I have a problem.
> > > I use the recovery log in rollforward mode. When DB backup is
finished,
> > > the recovery log utilization is not decreased in any way. I have to
> > > restart the server to accomplish this.
> > > An example: I started a backup when the recovery log utilization
was
> > > 26.9 %. It was an incremental which finished after about 10
minutes.
> > > Afterwards the recovery log utilization was 27.0% and was still
> > > increasing. After the restart of the server it was 0.4%.
> > > Has anyone seen this behaviour? Any idea what I can do? I will open
a
> > > PMR asap.
> > > BTW, the server is level 3.1.2.40 on AIX 4.2.1.
> > > Best regards
> > > Gerhard
> > >
> > > ---
> > > Gerhard Rentschler
email:g.rentschler AT rus.uni-stuttgart DOT de
> > > Regional Computing Center     tel.   ++49/711/685 5806
> > > University of Stuttgart       fax:   ++49/711/682357
> > > Allmandring 30a
> > > D 70550
> > > Stuttgart
> > > Germany