ADSM-L

Re: Recovery Log problems

1999-09-02 22:58:57
Subject: Re: Recovery Log problems
From: Steven P Roder <tkssteve AT REXX.ACSU.BUFFALO DOT EDU>
Date: Thu, 2 Sep 1999 22:58:57 -0400
>
> How big is your database?  How much does it change in a day?  I've never
> seen a log that big fill without operational problems preventing the
> regular backup or the triggered backup to fail...

My DB is too big, and that is why I am in the process of setting up a
second server, this time under AIX (primary one is Sun with 2 3575-L12's
with 4 3570-C1A's each) with a 3494 and 4 3590-B1A drives.

q db

Available Assigned   Maximum   Maximum    Page     Total      Used   Pct
Max.
    Space Capacity Extension Reduction    Size    Usable     Pages  Util
Pct
     (MB)     (MB)      (MB)      (MB) (bytes)     Pages
Util
--------- -------- --------- --------- ------- --------- --------- -----
-----
-----
   67,780   56,000    11,780    12,436   4,096 14,336,00 11,147,61  77.8
   67,780   56,000    11,780    12,436   4,096 14,336,00 11,147,61  77.8
77.8
                                                       0         3
On 8/22, it had 10,868,322
   8/29, it was 11,031,226

..but, school is back in session.  The biggest problem is running tasks
like Expiration or reclaimation (I do move data's "by Hand").  Expiration
takes about 4 days, so I can only make one pass/week.  The restartable
expiration in 3.1.2.30/40 is a lifesaver for me.

Full backup is done to DLT4000 and takes about 3:45 on 8/29.

Steve (unVMix Systems Programmer/Dude) Roder
(tkssteve AT ubvm.cc.buffalo DOT edu | tkssteve AT acsu.buffalo DOT edu | 
(716)645-3564 ,
   | http://ubvm.cc.buffalo.edu/~tkssteve)
<Prev in Thread] Current Thread [Next in Thread>