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
