ADSM-L

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

2009-01-07 10:29:44
Subject: Re: [ADSM-L] TDP for Oracle - multi channel restore
From: Richard Rhodes <rrhodes AT FIRSTENERGYCORP DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 7 Jan 2009 10:28:18 -0500
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 01/07/2009
09:24:15 AM:

> hi, just 2 quick questions :
>
> - what's your RESOURCEUTILIZATION parameter value ?
> - what's your MAX_NUM_MP allowed parameter value ?
>

RESOURCEUTIL is not specified, so it's at default.
MAX_NUM_MP on the node is 4.



>
> 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."