Grokbase › Groups › Oracle › oracle-l › January 2010
FAQ
Good Morning All,

I have clarification on rman backup to tape. Suppose if backup team increase
the netbackup streams from 2 to 8, will it decrease the database backup
completion time window? And also how to make changes on rman script to
configure the new streams build by backup team and how rman can communicate
to backup each stream data�s on each tapes separately... Thank You

-Naga.

Search Discussions

  • Marcin Przepiorowski at Jan 6, 2010 at 1:56 pm ⇧

    On Wed, Jan 6, 2010 at 1:32 PM, Nagaraj S wrote:
    Good Morning All,



    I have clarification on rman backup to tape. Suppose if backup team increase
    the netbackup streams from 2 to 8, will it decrease the database backup
    completion time window? And also how to make changes on rman script to
    configure the new streams build by backup team and how rman can communicate
    to backup each stream data�s on each tapes separately... Thank You
    It depend - if your database storage can give you enough throughput to
    fill 8 tape streams there is a chance to reduce a time.

    It's quite easy just add another channel with sbt_tape type to RMAN script.

    regards,
    Marcin Przepiorowski
  • Allen, Brandon at Jan 6, 2010 at 4:26 pm ⇧
    Agreed, plus it also depends on how many tapes they are writing to concurrently and the speed of those writes.

    Also, if you're using automatic channel configuration, then just change your RMAN configuration to use parallelism 3 like this:

    RMAN> CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 3 BACKUP TYPE TO BACKUPSET;

    Regards,
    Brandon

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org On Behalf Of Marcin Przepiorowski

    It depend - if your database storage can give you enough throughput to
    fill 8 tape streams there is a chance to reduce a time.

    It's quite easy just add another channel with sbt_tape type to RMAN script.

    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.
    --
    http://www.freelists.org/webpage/oracle-l
  • Jared Still at Jan 6, 2010 at 5:01 pm ⇧

    On Wed, Jan 6, 2010 at 5:32 AM, Nagaraj S wrote:

    Good Morning All,


    I have clarification on rman backup to tape. Suppose if backup team
    increase the netbackup streams from 2 to 8, will it decrease the database
    backup completion time window? And also how to make changes on rman script
    to configure the new streams build by backup team and how rman can
    communicate to backup each stream data�s on each tapes separately... Thank
    You
    If there are 8 drives available, then it may decrease the time required for
    a backup.
    If the network from the server to the tape library doesn't have the
    bandwidth to
    accommodate that much data, then the backups may actually take longer than
    with 2 drives.

    This is because tapes must be kept streaming to be efficient.
    When tape drives run out of data to write, they stop and rewind.
    When more data needs to be written, the tape drive must then
    seek to where it left of writing.

    Here's an article on the topic:
    http://www.computerworld.com/s/article/93057/Slow_down_those_streaming_tape_drives

    Increasing the number of drives in use will also make those drives
    unavailable for other backup jobs.

    Increasing the number of drives will also increase the number of tapes
    that must be vaulted (sent offsite)

    The real question is: Did the backup team do their homework when
    deciding to increase the number of drives from 2 to 8?

    Jared Still
    Certifiable Oracle DBA and Part Time Perl Evangelist
    Oracle Blog: http://jkstill.blogspot.com
    Home Page: http://jaredstill.com
  • Nagaraj S at Jan 6, 2010 at 5:21 pm ⇧
    yeah backup team doing testing to see if it improves backup timings..

    -Naga
    On Wed, Jan 6, 2010 at 10:31 PM, Jared Still wrote:
    On Wed, Jan 6, 2010 at 5:32 AM, Nagaraj S wrote:

    Good Morning All,


    I have clarification on rman backup to tape. Suppose if backup team
    increase the netbackup streams from 2 to 8, will it decrease the database
    backup completion time window? And also how to make changes on rman script
    to configure the new streams build by backup team and how rman can
    communicate to backup each stream data�s on each tapes separately... Thank
    You
    If there are 8 drives available, then it may decrease the time required for
    a backup.
    If the network from the server to the tape library doesn't have the
    bandwidth to
    accommodate that much data, then the backups may actually take longer than
    with 2 drives.

    This is because tapes must be kept streaming to be efficient.
    When tape drives run out of data to write, they stop and rewind.
    When more data needs to be written, the tape drive must then
    seek to where it left of writing.

    Here's an article on the topic:

    http://www.computerworld.com/s/article/93057/Slow_down_those_streaming_tape_drives

    Increasing the number of drives in use will also make those drives
    unavailable for other backup jobs.

    Increasing the number of drives will also increase the number of tapes
    that must be vaulted (sent offsite)

    The real question is: Did the backup team do their homework when
    deciding to increase the number of drives from 2 to 8?

    Jared Still
    Certifiable Oracle DBA and Part Time Perl Evangelist
    Oracle Blog: http://jkstill.blogspot.com
    Home Page: http://jaredstill.com
    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJan 6, '10 at 1:32p
activeJan 6, '10 at 5:21p
posts5
users4
websiteoracle.com

4 users in discussion

Nagaraj S: 2 posts Jared Still: 1 post Allen, Brandon: 1 post Marcin Przepiorowski: 1 post

Content

People

Support

Translate

site design / logo © 2022 Grokbase