Re: TSM restore media list

IF you want to know on node/filespace level you can look at the volumeusage 
table.
For example:

                   select distinct node_name, stgpool_name, volume_name
                          from volumeusage
                          order by node_name, stgpool_name, volume_name

I have this small perl script that makes its output more readable.

-Marcel

On Wed, Dec 03, 2003 at 03:35:21PM -0500, ZENG Brian (800043) wrote:
> I got you, Richard. This is exactly what is required from my point of view. 
> We need to do a diaster recovery rehearsal, which I need to get the Required 
> tapes to another location and restore whatever from there.
>
> In this case, I guess only option is to bring all the offsite tapes over and 
> put them ALL into the library.
>
> Another suggestion I got is to do a selective backup before DR, that way to 
> minimize the total time of restoration taken by having most recent data on 
> limited number of tapes. But what about the Database with no downtime 
> possible?
>
> Thanks,
> Brian
>
> -----Original Message-----
> From: Richard Sims [mailto:rbs AT BU DOT EDU]
> Sent: Wednesday, December 03, 2003 3:26 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: TSM restore media list
>
>
> >        How to find out the offsite media list required for specific 
> > restoration?
> >See, if I know the file or directory path and dates to restore, is there 
> >anyway
> >to find out which tape should be used?
>
> Brian - Whether onsite or offsite, the product provides no means for 
> determining
>         what volumes will be needed for a restoral of specific subsets of the
> backed up environment.  There is no command of feasible SQL method for 
> determining
> this in the general case.  Only in the simplest cases can there be any 
> certainty
> (e.g., filespace collocation, and only one tape thus far written for the
> filespace).  This drawback derives from the file-oriented nature of the 
> product,
> where the philosophy is you should not need to be concerned with where files 
> are
> on what tape volumes.  It's an excellent philosophy, but inconvenient when you
> are required to take some subset of your tapes to another environment to 
> perform
> restorals there.
>
>   Richard Sims         http://people.bu.edu/rbs

--
     ======--------         Marcel J.E. Mol                MESA Consulting B.V.
    =======---------        ph. +31-(0)6-54724868          P.O. Box 112
    =======---------        marcel AT mesa DOT nl                 2630 AC  
Nootdorp
__==== www.mesa.nl ---____U_n_i_x______I_n_t_e_r_n_e_t____ The Netherlands ____
 They couldn't think of a number,           Linux user 1148  --  counter.li.org
    so they gave me a name!  -- Rupert Hine  --  www.ruperthine.com