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