ADSM-L

Re: Recovery Log

2000-03-29 07:51:13
Subject: Re: Recovery Log
From: "Cook, Dwight E" <cookde AT BP DOT COM>
Date: Wed, 29 Mar 2000 06:51:13 -0600
You have your logmode set for rollforward and a DB backup should have
initiated...
Once the DB is backed up your log will return to a low value.
Check your DB trigger

I run mine in logmode normal and have across 12 servers for 4 years, so far
so good
In normal mode you shouldn't see the log ever get close to full, unless it
is small, you have lots of activity and a dbbackup is running.

Dwight

> ----------
> From:         Doherty, John (ANFIS)[SMTP:jdohe1 AT ANFIS.CO DOT UK]
> Reply To:     ADSM: Dist Stor Manager
> Sent:         Wednesday, March 29, 2000 6:26 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Recovery Log
>
> Can anyone tell me how best to manage space in the recovery log and DB.
>
> Last night I received the following messages:
>
> 03/29/2000 05:28:38 ANR0314W Recovery log usage exceeds 90 % of its
> assigned
> capacity.
> 03/29/2000 05:30:50 ANR0314W Recovery log usage exceeds 92 % of its
> assigned
> capacity.
> 03/29/2000 05:33:03 ANR0314W Recovery log usage exceeds 94 % of its
> assigned
> capacity.
> 03/29/2000 05:35:22 ANR0314W Recovery log usage exceeds 96 % of its
> assigned
> capacity.
> 03/29/2000 05:38:06 ANR0314W Recovery log usage exceeds 98 % of its
> assigned
> capacity.
>
> What is the normal course of events if the above happens ?
>
> I realise I can extend the recovery log.  But how do I know if it is being
> utilised properly.  I have also noticed that the utilisation counters have
> not been reset since 22/06/98.  Is this a problem.
>
> A display of my log file is as follows:
>
> ANS8000I Server command: 'QUERY LOG F=D'
>        Available Space (MB): 592
>      Assigned Capacity (MB): 592
>      Maximum Extension (MB): 0
>      Maximum Reduction (MB): 584
>           Page Size (bytes): 4,096
>          Total Usable Pages: 151,040
>                  Used Pages: 337
>                    Pct Util: 0.2
>               Max. Pct Util: 100.3
>            Physical Volumes: 4
>              Log Pool Pages: 128
>          Log Pool Pct. Util: 3.34
>          Log Pool Pct. Wait: 0.22
> Cumulative Consumption (MB): 722,834.19
> Consumption Reset Date/Time: 06/22/1998 15:10:41
>
> Looking at the above should I extend my log ?
>
>
> > John Doherty. Tel:   +44   (0)   141 275 7793
> >               Fax:  +44   (0)   141 275 9199
> >               Email: JDohe1 AT Anfis.co DOT uk
> >
> >       Technical Specialist, Storage Management L02S
> >
> > Email communications are not necessarily secure and may be intercepted
> or
> > changed after they are sent.  Abbey National Financial and Investment
> > Services  does not accept liability for any such changes. If you wish to
> > confirm the origin or content of this communication, please contact the
> > sender using an alternative means of communication.  This communication
> > does not create or modify any contract.  If you are not the intended
> > recipient of this communication you should destroy it without copying,
> > disclosing or otherwise using its contents.  Please notify the sender
> > immediately of the error.
> >
> > ABBEY NATIONAL FINANCIAL AND INVESTMENT SERVICES plc
> >         Registered Office Abbey National House 287 St Vincent Street
> >         Glasgow G2 5NB United Kingdom Registered in Scotland No 159852
> >
>
<Prev in Thread] Current Thread [Next in Thread>