I'm not an expert in UFS, but could the drive be getting fragmented?  Are
you running with compression, and could the data in the database be
getting more chaotic, thus increasing the size (as well as the time to
compress) of the compressed file?

--- "Patrick M. Hausen" <[EMAIL PROTECTED]> wrote:
> Hi all!
> 
> We have a database server that is backed up daily using Amanda
> to a dedicated tape drive.
> 
> Sun E3500
> Sun E1000 RAID, ~170 GB of storage
> LTO tape connected to LVD controller
> 
> One and only application on this system is an Oracle database
> server (8i). The tables are kept in one filesystem (UFS) and the
> database is shut down nightly to accomodate for the Amanda run.
> Despite of the dumps being "incremental", of course all the
files
> have changed during the day so we will get an "almost full
dump".
> 
> When I installed Amanda in June the nightly backup run took
> about 4.5 hours. This has continuously increased to more than
> 7 hours today - without any changes to hardware or configuration.
> The size of the table files has increased from 72 to 78 GB
> which doesn't quite qualify as the only reason ;-)
> 
> First thing I thought of was "UFS degradation when the FS is
almost
> full" - can't be, since the FS in question is around 170 GB and
> thus only 45% full with the currrent tables.
> 
> Obviously with a single host connected to a single drive and
> only so much storage we don't use a holding disk at the moment.
> 
> 
> Any ideas where to start searching?
> 
> Thanks,
> Patrick M. Hausen
> Technical Director
> -- 
> punkt.de GmbH         Internet - Dienstleistungen - Beratung
> Scheffelstr. 17 a     Tel. 0721 9109 -0 Fax: -100
> 76135 Karlsruhe       http://punkt.de
> 
> 
> 


=====
---
Wayne Johnson,             | There are two kinds of people: Those 
3943 Penn Ave. N.          | who say to God, "Thy will be done," 
Minneapolis, MN 55412-1908 | and those to whom God says, "All right, 
(612) 522-7003             | then,  have it your way." --C.S. Lewis

__________________________________________________
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/

Reply via email to