RE: To reduce RMAN backup time
- From: "Roger Xu" <roger_xu@xxxxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>, "Oracle-L@Freelists. Org (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 16 Jun 2005 16:20:54 -0500
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@xxxxxxxxxxxxx
[ mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Roger Xu
Sent: Thursday, June 16, 2005 3:30 PM
To: Allen, Brandon; Oracle-L@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@xxxxxxxxxxx]
Sent: Thursday, June 16, 2005 3:22 PM
To: Roger Xu; Oracle-L@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@xxxxxxxxxxxxx
[ mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Roger Xu
Sent: Thursday, June 16, 2005 1: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.
____________________________________________________________________
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
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@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.
____________________________________________________________________
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.
____________________________________________________________________
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
Other related posts:
