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