Dwight / Wanda / David,


Your advice was accurate and matched what I thought I would have to do.  I
was just scared of the risk so I was looking for alternatives.

But I did as y'all suggested.  Backed up today's DB tape, then restored
Sunday's.  Checked out all scratch tapes that had been used between Sunday
and today.  Oh - don't forget the volume history.
Loaded the primary source tape and exported that filespace.
Restored the DB backup from today.  Note that DB restores overwrite the
volume history and device config files so you should keep a safe copy
before the "old" restore.  Also, each restore launches a full DB backup so
you need to have your scratch tape inventory accurate before you launch
the DB restore.
Once I imported the data on the tape, I steered it to the desired tape
pool, then made a new copy to copypool.
Pulled both tapes and cleaned up the system config a bit.

Bottom line: I recovered 10 GB of irreplaceable data from 2-1/2 years ago.
 I lost no data and missed no backups in the process.  All it cost was the
one day of my labor to shepherd the various processes.

There are other backup products?

Thanks to all.

Tab







"Prather, Wanda" <Wanda.Prather AT JHUAPL DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
06/11/2003 09:00 AM
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: Recover data on tape that was deleted


Agreed.  Been there, done that before-
Since your tapes are in PENDING status, they haven't been written over
(which is what PENDING is for.)
So if you roll your DB back, they will be readable.

'Course, you gotta either take your system down, or have a "test" TSM
server
to do it with.

Grab yourself a jr. administrator and offer them the "golden opportunity"
to
practice your disaster recovery drill! :>)


-----Original Message-----
From: Dwight Cook [mailto:cookde AT US.IBM DOT COM]
Sent: Wednesday, June 11, 2003 9:49 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Recover data on tape that was deleted


You could
      identify some known scratch tapes NOW and in the past when that data
existed
      roll the environment back to when the deleted data existed
      export that filespace
      roll the environment back to current
      import the filespace

whew...

but will work...  (famous last words)

Dwight







                      Tab Trepagnier
                      <Tab.Trepagnier@L        To:
ADSM-L AT VM.MARIST DOT EDU
                      AITRAM.COM>              cc:
                      Sent by: "ADSM:          Subject:  Recover data on
tape that was deleted
                      Dist Stor
                      Manager"
                      <[email protected]
                      .EDU>


                      06/11/2003 08:35
                      AM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






TSM Server 5.1.6.5 on AIX 4.3.3 ML-11

While cleaning up old data in our TSM system, we deleted a filespace from
which a year-end snapshot had been taken.  Upon the deletion of the
filespace, TSM notified us that both the primary tape and the copy tape
had toggled to "pending" status.  This occurred on Monday during our
weekly maintenance cycle.

The last prior DB backup is from Sunday morning. We have taken daily DB
backups since and will take another today.

Is there any way to recover that tape's data?  I've thought about rolling
the system back to Sunday, but I would have to eventually roll it forward
to today to prevent orphaning the backups that have occurred since then.

What can I do?

Thanks in advance.

Tab Trepagnier
TSM Administrator
Laitram LLC