Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: rman compressed backup is much smaller but very slow
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
> > 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
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 02 2006 - 06:19:51 CDT
![]() |
![]() |