RE: To reduce RMAN backup time

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Thu, 16 Jun 2005 16:20:54 -0500
Message-ID: <A6801E8A03316A4DA597866F77A013F7059C95C9@irv2kexch01.tx.bg.corp>

SQL> /

           3045 /oback/obckp1/datafiles/PR2_10794_1.data     2005/06/15-14:49 2005/06/15-15:39
           2984 /oback/obckp2/datafiles/PR2_10795_1.data     2005/06/15-14:49 2005/06/15-15:38
           2882 /oback/obckp2/datafiles/PR2_10796_1.data     2005/06/15-15:39 2005/06/15-16:27
           2874 /oback/obckp1/datafiles/PR2_10797_1.data     2005/06/15-15:40 2005/06/15-16:28
           2761 /oback/obckp2/datafiles/PR2_10798_1.data     2005/06/15-16:27 2005/06/15-17:13
           2454 /oback/obckp1/datafiles/PR2_10799_1.data     2005/06/15-16:28 2005/06/15-17:09
           2307 /oback/obckp1/datafiles/PR2_10800_1.data     2005/06/15-17:09 2005/06/15-17:47
          33801 /oback/obckp2/datafiles/PR2_10801_1.data     2005/06/15-17:13 2005/06/16-02:36
            615 /oback/obckp1/datafiles/PR2_10802_1.data     2005/06/15-17:47 2005/06/15-17:58
            611 /oback/obckp1/datafiles/PR2_10803_1.data     2005/06/15-17:58 2005/06/15-18:08
            626 /oback/obckp1/datafiles/PR2_10804_1.data     2005/06/15-18:08 2005/06/15-18:19
            627 /oback/obckp1/datafiles/PR2_10805_1.data     2005/06/15-18:19 2005/06/15-18:29
            628 /oback/obckp1/datafiles/PR2_10806_1.data     2005/06/15-18:29 2005/06/15-18:40
            593 /oback/obckp1/datafiles/PR2_10807_1.data     2005/06/15-18:40 2005/06/15-18:50
            608 /oback/obckp1/datafiles/PR2_10808_1.data     2005/06/15-18:50 2005/06/15-19:00
            610 /oback/obckp1/datafiles/PR2_10809_1.data     2005/06/15-19:00 2005/06/15-19:10
            600 /oback/obckp1/datafiles/PR2_10810_1.data     2005/06/15-19:10 2005/06/15-19:20
            606 /oback/obckp1/datafiles/PR2_10811_1.data     2005/06/15-19:20 2005/06/15-19:31
            606 /oback/obckp1/datafiles/PR2_10812_1.data     2005/06/15-19:31 2005/06/15-19:41
            601 /oback/obckp1/datafiles/PR2_10813_1.data     2005/06/15-19:41 2005/06/15-19:51
            599 /oback/obckp1/datafiles/PR2_10814_1.data     2005/06/15-19:51 2005/06/15-20:01
            600 /oback/obckp1/datafiles/PR2_10815_1.data     2005/06/15-20:01 2005/06/15-20:11
            586 /oback/obckp1/datafiles/PR2_10816_1.data     2005/06/15-20:11 2005/06/15-20:21
            586 /oback/obckp1/datafiles/PR2_10817_1.data     2005/06/15-20:21 2005/06/15-20:31
            578 /oback/obckp1/datafiles/PR2_10818_1.data     2005/06/15-20:31 2005/06/15-20:41
            579 /oback/obckp1/datafiles/PR2_10819_1.data     2005/06/15-20:41 2005/06/15-20:51
            576 /oback/obckp1/datafiles/PR2_10820_1.data     2005/06/15-20:51 2005/06/15-21:00
            565 /oback/obckp1/datafiles/PR2_10821_1.data     2005/06/15-21:00 2005/06/15-21:10
            564 /oback/obckp1/datafiles/PR2_10822_1.data     2005/06/15-21:10 2005/06/15-21:19
            541 /oback/obckp1/datafiles/PR2_10823_1.data     2005/06/15-21:19 2005/06/15-21:28
            532 /oback/obckp1/datafiles/PR2_10824_1.data     2005/06/15-21:29 2005/06/15-21:37
            509 /oback/obckp1/datafiles/PR2_10825_1.data     2005/06/15-21:38 2005/06/15-21:46
            484 /oback/obckp1/datafiles/PR2_10826_1.data     2005/06/15-21:46 2005/06/15-21:54
            453 /oback/obckp1/datafiles/PR2_10827_1.data     2005/06/15-21:54 2005/06/15-22:02
            453 /oback/obckp1/datafiles/PR2_10828_1.data     2005/06/15-22:02 2005/06/15-22:10
            438 /oback/obckp1/datafiles/PR2_10829_1.data     2005/06/15-22:10 2005/06/15-22:17
            429 /oback/obckp1/datafiles/PR2_10830_1.data     2005/06/15-22:17 2005/06/15-22:24
            434 /oback/obckp1/datafiles/PR2_10831_1.data     2005/06/15-22:24 2005/06/15-22:31
            444 /oback/obckp1/datafiles/PR2_10832_1.data     2005/06/15-22:32 2005/06/15-22:39
            427 /oback/obckp1/datafiles/PR2_10833_1.data     2005/06/15-22:39 2005/06/15-22:46
            412 /oback/obckp1/datafiles/PR2_10834_1.data     2005/06/15-22:46 2005/06/15-22:53
            428 /oback/obckp1/datafiles/PR2_10835_1.data     2005/06/15-22:53 2005/06/15-23:00
            416 /oback/obckp1/datafiles/PR2_10836_1.data     2005/06/15-23:00 2005/06/15-23:07
            406 /oback/obckp1/datafiles/PR2_10837_1.data     2005/06/15-23:08 2005/06/15-23:14
            414 /oback/obckp1/datafiles/PR2_10838_1.data     2005/06/15-23:14 2005/06/15-23:21
            412 /oback/obckp1/datafiles/PR2_10839_1.data     2005/06/15-23:21 2005/06/15-23:28
            415 /oback/obckp1/datafiles/PR2_10840_1.data     2005/06/15-23:28 2005/06/15-23:35
            403 /oback/obckp1/datafiles/PR2_10841_1.data     2005/06/15-23:35 2005/06/15-23:42
            348 /oback/obckp1/datafiles/PR2_10842_1.data     2005/06/15-23:42 2005/06/15-23:48

49 rows selected.

SQL> l
1 select ELAPSED_SECONDS,

  2         HANDLE,
  3         to_char(START_TIME,'YYYY/MM/DD-HH24:MI'),
  4         to_char(COMPLETION_TIME,'YYYY/MM/DD-HH24:MI')

5 from v$backup_piece
6 where to_char(START_TIME,'YYYYMMDD') = to_char(sysdate - 1,'YYYYMMDD') 7* order by START_TIME
SQL>exit
$ ls -l /oback/obckp2/datafiles/PR2_10801_1.data
-rw-r----- 1 orapr2 dba 497462722560 Jun 16 02:36 /oback/obckp2/datafiles/PR2_10801_1.data
I think I am going to set "MAXPIECESIZE = 40G;" and try it.

-----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:30 PM
To: Allen, Brandon; Oracle-L_at_Freelists. Org (E-mail) Subject: RE: To reduce RMAN backup time

I just found out every time there is a backup piece takes 9 hours while others take less than an hour. What does this mean?

-----Original Message-----

From: Allen, Brandon [ mailto:Brandon.Allen_at_OneNeck.com] Sent: Thursday, June 16, 2005 3:22 PM
To: Roger Xu; Oracle-L_at_Freelists. Org (E-mail) Subject: RE: To reduce RMAN backup time

Roger,

Could it be that the additional disk you are now writing to is slower than the other single disk you were writing to before?

Are both backup pieces running in parallel with similar start and completion times, or are they running sequentially? I had this happen once due to the setting of filesperset or some other parameter (can't remember the details).

Regards,
Brandon

-----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 1: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.

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

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.