Actually if you simply do a "query content vol_ser" you will only see
the active files left on the tape...
______________________________ Reply Separator _________________________________
Subject: Re: Chewed 3590 cartridge
Author: mersch (mersch AT UNI-MUENSTER DOT DE) at unix,mime
Date: 5/19/98 2:02 AM
Hi,
we lost three 3590 tapes due to "ANR8359E Media fault detected ...". The
tapes always belonged to storage pools, which we do not back up. So all I
did was to delete the volumes (DISCARDDATA=YES), informed the affected
users and urged them to do an incremental.
These things happened when we were on V.2. I did not see any possibility
to determine, whether the affected backups were active or not. So I
decided to not worry about it. (What else could I do, if I were able to
identify the inactive copies?)
An interesting question is, whether the SQL interface of V.3 allows us
to identify inactive copies on a storage pool volume. A quick look at
the SQL table layout does not give me any clue :-(
Maybe the DEACTIVATE_DATE in the BACKUPS table gives the wanted
information, but how do I get the connection from an entry in the
CONTENTS table to the corresponding entry in the BACKUPS table? Any ideas?
--
Reinhard Mersch Westfaelische Wilhelms-Universitaet
Reinhard Mersch Westfaelische Wilhelms-Universitaet
Universitaetsrechenzentrum, Roentgenstrasse 13, 48149 Muenster, Germany
E-Mail: mersch AT uni-muenster DOT de Phone: +49(251)83-31583
Trevor Foley writes:
> Hi,
>
> One of our 3590 drives decided that is was hungry the other day, and
> made a meal out of one of our cartridges. I can do a query content of
> the volume and get a list of files (~13,000 of them). How do I determine
> when each of these files was backed up, whether they are active or not,
> etc. We do not have copy pools for this storage pool, otherwise I would
> just mark the volume as destroyed and restore the data from the copy
> pool.
>
> But what I need to work out is what we have lost. For the files that are
> on that volume and active, again it isn't a problem, because if I
> deleted all of the files on the volume, the active ones would be backed
> up again next incremental backup. It is the non-active ones that I am
> concerned about.
>
> Has anyone else had a 3590 cartridges chewed? Due to this problem, and a
> few others of the past few months, we are reviewing our decision not to
> implement copy pools.
>
>
> Trevor
> ------------------------------------------------------------------------
> ------------------------------------------------
> Trevor Foley
> Bankers Trust Australia Limited
> Phone: 61-2-9259 3944 Fax: 61-2-9259 2659
|