DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Friday, June 21, 2013

Oracle 11g Parallel Backup of the Same Datafile

Parallel Backup of the Same Data files in Oracle 11g RMAN
 
In Oracle Database 11g RMAN, the channels can break the datafiles into chunks known as "sections."

we can specify the size of each section. Here's an example:
 
RMAN> run {
2>      allocate channel c1 type disk format '/backup1/%U';
3>      allocate channel c2 type disk format '/backup2/%U';
4>      backup
5>      section size 500m
6>      datafile 6;
7> }
 
This RMAN command allocates two channels and backs up the users' tablespace in parallel on two channels.
Each channel takes a 500MB section of the datafile and backs it up in parallel. This makes backup of large files faster.
When backed up this way, the backups show up as sections as well.
 
RMAN> list backup of datafile 6;
...

...
    List of Backup Pieces for backup set 901 Copy #1
    BP Key  Pc# Status      Piece Name
    -------    ---  -----------      ----------
    2007    1   AVAILABLE   /backup1/9dhk7os1_1_1
    2008    2   AVAILABLE   /backup2/9dhk7os1_1_1
    2009    3   AVAILABLE   /backup1/9dhk7os1_1_3
    2009    3   AVAILABLE   /backup2/9dhk7os1_1_4
 
Some points to remember about multisection backups include:
•If the section size is larger than the file size, RMAN does not use a multisection backup for the file.
•If the section size is so small that more than 256 sections would be produced, RMAN increases the section size such that 256 sections will be created.
•SECTION SIZE and MAXPIECESIZE cannot be used together.
•A backup set never contains a partial datafile, regardless of whether or not it is a multisection backup.

1 comment:

Sridevi K said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.