Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Tuning RMAN backup and recovery

Re: Tuning RMAN backup and recovery

From: <krish.hariharan_at_quasardb.com>
Date: Thu, 15 Nov 2007 15:22:41 -0800 (PST)
Message-ID: <48648.209.244.4.106.1195168961.squirrel@webmail.quasardb.com>


Don,

My experience is with VLDB (30TB) rman backups going directly to tape
(disk cache) averaging 1G/channel-min. However, I am curious about the
following

CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO COMPRESSED BACKUPSET I did a benchmark with CAS technology based RMAN backup and the limiting factor was CPU not Disk IO. My gut feel is that you may be CPU bound based on the ratio of bytes read per sec to bytes written per sec, due to backup set compression.

Can you benchmark a smaller backup (couple of files) with and without backupset compression?

The alternative if you want to use compressed backup sets, if you are thread constrained but not CPU constrained, and should CPU be your bottleneck, is to increase the number of channels to the extent your disk subsystem would allow, to meet your SLA target.

If on the other hand you are disk constrained, which I suspect you are not, then you may be able to speed up by using ASM or direct io options
(if not already set) and should the underlying array/disk has io head
room.

-Krish

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 15 2007 - 17:22:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US