Hi all! Andreas Baier wrote:
> my answer seems to be a bit off-topic. but have you ever given a > Lgical Volume Manager a try - you could stop your oracle-instance, > issue the snapshot of the filesystem, startup your oracle and have > almost all-the time in the world for your backup while your users are > able to use the database with only a small performance impact. I do > this on a (smaller but 24/7) Oracle 8i database. But why - of course! Unfortunately the big expensive Sun/Oracle system was neither designed nor sold by us. We just "inherited" the system when problems started. The backup concept of the original seller/supporter was to use the internal DDS drive |-) So after we took over service and most of the budget already spent Amanda was an obvious solution - just add a "real" tape drive, they almost choked on the price of that already. We did offer volume management but for this component the price was prohibitive. Seems like we have a big sales opportunity now ;-)) > Fragmentation *might* be a cause for this performance ( 3,5 MB/s ) but > you would have noticed this with a poor performance of your > oracle-performance as-well. Well, the database is _only_ accessed by some web application. There are other limiting factors in this setup as far as responsiveness is concerned. I used to believe UFS wasn't prone to fragmentation as long as you keep your 10% reserve. Seems like very few very big files are sort of a pathological case. > What is about your network you told your performance in June was about > 4,5 MB/s - could there be a network-bottleneck? It's _local_ backup - no network communication involved. Well, OK, it _is_ a network socket and there will be quite a bit of context switching. 4,6 MB/s would be acceptable - it just keeps getting even slower. > Perhaps you�ll give the holdingdisk a try - you moght not regret. This is the first shot we will take - though I'm not very confident since the holding space will have to be on the same RAID in the same (only existing) partition as the database tables. I'll let you know the results. 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
