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

Home -> Community -> Mailing Lists -> Oracle-L -> Parallelizing RMAN Backup

Parallelizing RMAN Backup

From: Pat Howe <phowe_at_Illuminet.com>
Date: Thu, 28 Feb 2002 15:01:36 -0800
Message-ID: <F001.0041C035.20020228150136@fatcity.com>

> I am researching RMAN and I am trying to understand how to parallelize the
> backup.
> I have come across the following statement in various papers and in the 8i
> Backup and Recovery Course Material :
>
> It is important to set FILESPERSET in the backup.
> This will ensure that each allocated channel only processes the specified
> number of files.
> If you DO NOT specify FILESPERSET then the backup would only be undertaken
> by "1 channel" and "all other allocated channels would sit idle".
>
> Yet in the "8.1.6 RMAN User's Guide and Reference" it contradicts this (pg
> 1-31) :
>
> The number of channels that you allocate affects the degree of parallelism
> within the command.
> RMAN internally handles parallelization. You only need to specify :
> > 1 'allocate channel' command
> The objects that you want to backup
> Parallelism is exploited only within the context of a single command.
>
> So it does not mention that you HAVE TO specify the FILESPERSET statement.
>
> On digging further into the FILESPERSET statement the manual states (pg
> 1-36) :
> The default value of this parm is calculated by RMAN as follows ;
> RMAN takes the lower of the following 2 values ; 64 or
> number-of-files/number-of-channels.
>
> Page 1-37 gives an example of using the Default FILESPERSET - and how RMAN
> would parallelize the backup.
>
> Which is right ?
> Do you have to specifically specify the FILESPERSET parm in the BACKUP
> command for RMAN to parallelize the backup operation?
> or
> Can you leave it out of the BACKUP command and use the default value ?
>
>
> Thanks in advance
>
> _________________________
> Patrick J. Howe
> Oracle DBA
> Illuminet Inc. (Carrier Division of Verisign)
> 4501 Intelco Loop SE
> Olympia, WA 98507
> Email : phowe_at_illuminet.com
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Pat Howe
  INET: phowe_at_Illuminet.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Feb 28 2002 - 17:01:36 CST

Original text of this message

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