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: rman parallel processes

Re: rman parallel processes

From: Christo Kutrovsky <kutrovsky.oracle_at_gmail.com>
Date: Wed, 19 Dec 2007 16:53:18 -0500
Message-ID: <52a152eb0712191353y7e44b954o767531f4e34d955a@mail.gmail.com>


Depends on your underlying storage for that "disk". If you have any kind of raid, chances are it will be faster as you will have a higher IO queue. Remember you need to have more then 1 io at any given time to benefit from RAID.

Seems like this is Oracle 9i, but if you were on 10g, you could be using compressed backupsets, in which case chances are you will definetelly increase backup speed as your limiting factor would be CPU and parallelising will allow you to use more CPUs for the backup.

-- 
Christo Kutrovsky
DBA Team Lead
The Pythian Group - www.pythian.com
I blog at http://www.pythian.com/blogs/


On 12/19/07, Joe Smith <joe_dba_at_hotmail.com> wrote:

> Does it make any sense to run 4 processes for a rman full database backup
> when you have configured only 1 default channel?
>
> The channel is a disk and the backup files are all going to that same disk.
>
> CONFIGURE DEVICE TYPE DISK PARALLELISM 4; # default
>
> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT
> '/u01/backup/oracle_sid/bu.d%d.t%t.s%s.p%p' MAXPIECESIZE 1
> G;
>
>
> Is this going to run faster or the fact of a single disk will slow it down?
>
> thanks.
>
>
>
> ________________________________
> i'm is proud to present Cause Effect, a series about real people making a
> difference. Learn more
-- Christo Kutrovsky Senior Database/System Administrator The Pythian Group - www.pythian.com I blog at http://www.pythian.com/blogs/ -- http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 19 2007 - 15:53:18 CST

Original text of this message

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