RE: To reduce RMAN backup time

From: Hollis, Les <Les.Hollis_at_ps.net>
Date: Thu, 16 Jun 2005 15:27:26 -0500
Message-ID: <683E0A1C82D75246BD9F4E01F77CBB0FB5EF7A@pscdalpexch02.perotsystems.net>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu Sent: Thursday, June 16, 2005 3:05 PM
To: Oracle-L_at_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_at_freelists.org
[ mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Roger Xu Sent: Thursday, June 16, 2005 2:27 PM
To: Oracle-L_at_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_at_dp7uptx.com.
--

http://www.freelists.org/webpage/oracle-l

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 16 2005 - 16:32:50 CDT