ADSM-L

Re: [ADSM-L] TDP for Oracle - multi channel restore

2009-01-07 09:25:30
Subject: Re: [ADSM-L] TDP for Oracle - multi channel restore
From: goc <gooooc AT GMAIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 7 Jan 2009 15:24:15 +0100
hi, just 2 quick questions :

- what's your RESOURCEUTILIZATION parameter value ?
- what's your MAX_NUM_MP allowed parameter value ?


On Wed, Jan 7, 2009 at 3:15 PM, Richard Rhodes
<rrhodes AT firstenergycorp DOT com> wrote:
> Hello,
>
> We are still fairly new to RMAN/TDPO backups, and trying to understand
> behavior.
>
> We have one 10tb database that performs RMAN backups to TSM using one
> tape drive (one channel).  Oracle datafiles are interleaved (not sure of
> the level).
>
> We are now performing a full restore on this database.  The dba allocated
> 4 channels for the restore (4 tape drives).  We started getting session
> timeouts.  It looks like Oracle was asking for aggregate files on different
> channels that in TSM are on the same tape.  This caused tape contention
> and session timeouts. The restore was stopped and changed to a
> single channel.
>
> I've been trying to find info on issues/limitations around  RMAN/TDPO
> restores
>  with multiple channels, but not finding much info.
>
> Questions:
>
> 1)  Does the number of channels on a restore have to be the same or less
> than the number used for the backup?
>
> 2)  Is it even possible to do multi channel restores?  In other words, does
> RMAN have knowledge of the tape volumes so as to not cause
> tape contention across channels?
>
>
> -----------------------------------------
> The information contained in this message is intended only for the
> personal and confidential use of the recipient(s) named above. If
> the reader of this message is not the intended recipient or an
> agent responsible for delivering it to the intended recipient, you
> are hereby notified that you have received this document in error
> and that any review, dissemination, distribution, or copying of
> this message is strictly prohibited. If you have received this
> communication in error, please notify us immediately, and delete
> the original message.
>



--

Joan Crawford  - "I, Joan Crawford, I believe in the dollar.
Everything I earn, I spend."