RE: To reduce RMAN backup time

From: "Hollis, Les" <Les.Hollis@xxxxxx>
To: <roger_xu@xxxxxxxxxxx>, "Oracle-L@Freelists. Org (E-mail)" <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 16 Jun 2005 15:27:26 -0500
Try setting parallelism


Parallelization of Backup Sets
You can configure parallel backups by setting the PARALLELISM option of
the CONFIGURE command to greater than 1 or manually allocate multiple
channels. RMAN parallelizes its operation and writes multiple backup
sets in parallel. The server sessions divide the work of backing up the
specified files.=20
Example
         RMAN> run {
       2>    allocate channel c1 type sbt;
       3>    allocate channel c2 type sbt;
       4>    allocate channel c3 type sbt;
       5>    backup
       6>       incremental level =3D 0
       7>       format '/disk1/backup/df_%d_%s_%p.bak'
       8>       (datafile 1,4,5 channel c1 tag=3DDF1)
       9>       (datafile 2,3,9 channel c2 tag=3DDF2)
      10>       (datafile 6,7,8 channel c3 tag=3DDF3);
      11>    alter system archive log current;
      12> }


Of course this only puts them to one location...in this case sbt

But maybe you can work the syntax out

Since current run command is not doing parallel  (possibly) try setting
parallelization with your configure command

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Roger Xu
Sent: Thursday, June 16, 2005 3:05 PM
To: Oracle-L@Freelists. Org (E-mail)
Subject: RE: To reduce RMAN backup time

I am trying to find out why "2 channel / 2 filesystem / 2 controller"
does not faster than "1 channel " ?
Anything I need to set in RMAN? pool size? buffer size?


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[ mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Roger Xu
Sent: Thursday, June 16, 2005 2:27 PM
To: Oracle-L@Freelists. Org (E-mail)
Subject: To reduce RMAN backup time


Hi list,
I am trying to reduce RMAN backup time by streaming backup to 2
different filesystem on two difference controller.

But it ended up taking a little bit longer than backup to 1 filesystem.

Any comments?

Thanks,

Roger Xu



P.S.

run {

allocate channel t1 type disk format
'/oback/obckp1/datafiles/PR2_%s_%p.data';

allocate channel t2 type disk format
'/oback/obckp2/datafiles/PR2_%s_%p.data';

backup

(database include current controlfile);

backup

format '/oback/redo-logs/PR2_%s_%p.logs'

archivelog all;

}


This e-mail is intended solely for the person or entity to which it is
addressed and may contain confidential and/or privileged information.
Any review, dissemination, copying, printing or other use of this e-mail
by persons or entities other than the addressee is prohibited. If you
have received this e-mail in error, please contact the sender
immediately and delete the material.
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email
Security System. Any questions please call 972-721-8257 or email your
request to tech_support@xxxxxxxxxxxx
--
//www.freelists.org/webpage/oracle-l

For technical support please email tech_support@xxxxxxxxxxx or you can
call (972)721-8257.
This email has been scanned for all viruses by the MessageLabs Email
Security System.



This e-mail is intended solely for the person or entity to which it is
addressed and may contain confidential and/or privileged information.
Any review, dissemination, copying, printing or other use of this e-mail
by persons or entities other than the addressee is prohibited. If you
have received this e-mail in error, please contact the sender
immediately and delete the material.=20
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email
Security System. Any questions please call 972-721-8257 or email your
request to tech_support@xxxxxxxxxxxx
--
//www.freelists.org/webpage/oracle-l

--
//www.freelists.org/webpage/oracle-l
RE: To reduce RMAN backup time

Other related posts:
