DB restored, data lost?

[staperidze]

Hi, all!
I have following situation;
TSM DB crashed 07/29 at ~10AM
Last DB backup was dated 07/28 at 12:00AM

Old volumehistory:
2008/07/28 17:50:05 STGDELETE 0 0 0 LTO_DC 830N
2008/07/28 17:50:05 STGDELETE 0 0 0 LTO_DC 813N
2008/07/28 23:42:06 STGNEW 0 0 0 LTO_DC 89L3
2008/07/29 00:29:56 STGNEW 0 0 0 LTO_DC 98L3
2008/07/29 05:00:07 STGNEW 0 0 0 LTO_DC 807N


volumehistory after DB restoration
2008/07/29 10:17:38 BACKUPFULL 387 0 1 LTO_DC 98L3
2008/07/29 10:17:54 STGDELETE 0 0 0 LTO_DC 830N
2008/07/29 10:17:54 STGDELETE 0 0 0 LTO_DC 813N


TSM reused previously STGNEW'ed volume 98L3 for DB backup right after restore.
830N and 813N were STGDELETE'd both before and after DB restore, and AUDIT VOL on these volumes was successfull.

When I make AUDIT VOLUME on 89L3 or 98L3 or 807N I receive:
ANR2401E AUDIT VOLUME: Volume 89L3 is not defined in a storage pool.
ANS8001I Return code 11.

QUERY VOL doesn't show 89L3, but QUERY LIBVOL does show it in list.

During AUDIT LIBRARY process TSM tried to use 807N for backup client files, but failed with TAPE RETENTION wait timeout because of AUDIT library.

I haven't my last backup of clients files and I think it placed on 89L3 or 89L3 or 807N.
QUERY CONTENT 89L3 shows error mentioned above:
ANR2401E AUDIT VOLUME: Volume 89L3 is not defined in a storage pool.
ANS8001I Return code 11.


I already tried to make checkout/checkin tape, but nothing helps.
What can be done with it?

 

[moon-buddy]

89L3 is a DB backup tape and will not show in any storage pool. Thus, the error you are getting is correct.

You basically don't checkout DB backup tapes but you use the "move drm" command.

 

[staperidze]

So where can be my data?
I'm running this query:
select * from CONTENTS where node_name='NODE1' and file_name like '// BACKUP_20080728_%'

and don't see files backed up between TSM DB backup and failure.
Which tapes can contain it? I think it is one of 89L3 or 98L3 or 807N. And no one of this tapes report it's contents: first two tapes report error "Now int stgpool" and 807N reports "empty".

 

[nezih]

try to define volume to storage pool first and audit it again

 

[bgc]

Any change

Any change prior to DB crash, those four files may need replace as original state as well (dsmserv.opt dsmserv.dsk devconf.out and volhist.out). You should have them backup daily

 

[staperidze]

Defining vol to stgpool shows an error.
I have backup of system dsmsta.opt and so on.
Hoping for success, I awaited for new backup.
Total: 10 hours without backup.