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
|