RE: rman compressed backup is much smaller but very slow

From: Spears, Brian <BSpears_at_Limitedbrands.com>
Date: Wed, 2 Aug 2006 07:19:51 -0400
Message-ID: <50938E6468CFED40AE0FD7A507D96D3405A669F9@EXCHSERV2.Limited.brands.com>

When I turned on the compression, all the 4 cpu's just pegged on a pretty good solid machine because we had 4 threads. We have played around a lot with tuning the backups which made the difference. We have backed up to Disk and tape. Pros/cons with both like write to multiple tapes as recovery is faster etc. I think we get about 160gig backed up per hour on average

Brian

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tomi Wijanto
Sent: Wednesday, August 02, 2006 6:09 AM To: oracle-l_at_freelists.org
Subject: Re: rman compressed backup is much smaller but very slow

It's seem that your system is I/O bound. Smaller backup size result in faster time.

Mine seems to be CPU bound.

regards,
tomi

"Radoulov, Dimitre" <cichomitiko_at_gmail.com> wrote:

> > Could someone shared their experieces on
> compressed
> > backup, especially with big sized database.
>
> Red Hat Enterprise Linux ES release 3 (Taroon Update
> 4)
> Oracle Database 10g Release 10.2.0.2.0 SE
>
> Not a big size database: 30GB (~18GB used), backed
> up on a NFS mounted drive (all filesystems are ext3
> type).
>
> full backup without compress: backup sets size
> ~13GB, elapsed 37min
> full backup with compress: backup set size < 2GB,
> elapsed 26min
>
> BACKUP OPTIMIZATION OFF
> PARALLELISM 1 (SE doesn't support parallelism > 1)
>
>
> Regards
> Dimitre

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 02 2006 - 06:19:51 CDT