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:[EMAIL PROTECTED]
> Sent: Wednesday, December 03, 2003 3:26 PM
> To: [EMAIL PROTECTED]
> 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
=======--------- [EMAIL PROTECTED] 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
