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
> >
>
|
|
|