DB restore without volhist and devconfig

kimt

ADSM.ORG Member
Joined
Mar 20, 2008
Messages
10
Reaction score
0
Points
0
PREDATAR Control23

Hi all,

I'm pretty green when it comes to the world of TSM.
The issue I'm having is that:

I have an old tsm server, it died … dbbackup and volhist/devconfig …were backup to tape….but the volhist/devconfig files were on the physical box….and now that box is dead (won’t start up) I'm unable to check the volhist to find out which volumes has the
dbbackup…

There is a new tsm server instance on another physical box, that was meant to replace the one that failed…
the closest thing I can think of is to do a restore db, and just plug in the volume names one at a time to either get some progress or
an error message… is that the right approach method? Is there another (better) way?

When defining the library, drives, volumes on the new server, I checked in the volumes as private, rather than scratch because I didn't want the
risk the scratch status overwriting any data. Was I correct in setting the status? Would doing an audit of the volumes help with determining the data/location
of the DB backup data of the former tsm server?

your time and assistance is appreciated,

Kim t.
 
Last edited:
PREDATAR Control23

How have you been doing DB Backups? Are you using DRM? If you are using DRM, then a "prepare" plan is generated and, hopefully, has been stored or copied offsite.

If you have the "prepare" or DR plan, it is a matter of exploding its contents and executing it.

Without the configuration files (or without the "prepare" plan) most of your recovery efforts will have to be a hit or miss - like you need to know what the size of the database and logs are, the number of database and/or log volumes, etc.
 
PREDATAR Control23

Rudy/Ed,

thanks for the prompt response,
I will take a look at that link, and try to follow that....hopefully without any more complications...

I do not believe, any DRM was done on that system, and even if it was....I don't think, there was an 'offsite' copy...which is the problem...I remember seeing some files that looked like they were for DRM...but they were on the tsm server box...that now...no longers starts up at all...
 
PREDATAR Control23

Manually recreating a devconfig file is possible and all you need to know is the current configuration. The bigger problem is finding the DBBackup without having the volhist file or a different list that has it. Depending on the number of tapes you're dealing with, you could attempt to restore the DB from each one until you get a successful restore and then note the date/time of the last activity in the activity log. Keep going until you find the newest DBBackup and then keep that one. If the number of tapes is too large, setup the new TSM server as a new server and point all the clients to it (start everything from scratch) and then perform the "Great TSM DB Hunt" like described above and export/import the historical data into the new TSM DB.

Good luck and remember to keep an offsite copy of the VolHist or a list of DBBackup volumes.

-Aaron
 
PREDATAR Control23

Hi All,

Here's the update...


Here are some of the output of the command from ‘dsmserv display dbbackupvolume devc=<devclass> volumenames=<volume names, 1,2>

When I entered in that command, if I was searching through multiple volumes…and to my understanding…if it didn’t find the contents
it was looking for on the first volume in the series..it would have an error then return you to the command prompt… so I had to manually
input the volume name one at a time, rather than doing “volumenames=vol1,vol2,vol3” instead it was “volumenames=vol1” then
“volumenames=vol2”, etc …til I went through 19-20 tapes…fortunately that wasn’t too bad, not like hundreds…

This first part was the result of the command, FINDING a dbbackup volume:
----
C:\Program Files\Tivoli\TSM\server>dsmserv display dbbackupvolume devc=ltoclass
volumenames=001373
ANR0900I Processing options file c:\program files\tivoli\tsm\server1\dsmserv.o-
pt.
ANR7800I DSMSERV generated at 08:35:01 on Jul 24 2008.

Tivoli Storage Manager for Windows
Version 5, Release 5, Level 1.0

Licensed Materials - Property of IBM

(C) Copyright IBM Corporation 1990, 2007.
All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.

ANR4726I The ICC support module has been loaded.
ANR8200I TCP/IP Version 4 driver ready for connection with clients on port
1500.
ANR8302E I/O error on drive DRIVE1 (mt2.0.0.2) with volume (OP=OFFL, Error
Number=21, CC=0, KEY=02, ASC=04, ASCQ=02,
SENSE=70.00.02.00.00.00.00.1C.00.00.-
00.00.04.02.00.00.10.12.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.02,
De-
scription=An undetermined error has occurred). Refer to Appendix C in the
'Messages' manual for recommended action.
ANR8358E Audit operation is required for library L40.
ANR8337I LTO volume 001373 mounted in drive DRIVE1 (mt2.0.0.2).
ANR1363I Input volume 001373 opened (sequence number 1).
ANR1364I Input volume 001373 closed.

Date/Time: 09/16/2008 04:22:01
Volume Type: BACKUPFULL
Backup Series: 3,052
Backup Operation: 0
Volume Seq: 1
Device Class: LTOCLASS
Volume Name: 001373
---
Granted, I’m not sure of the …i/o errors and all those sense 00.00.00, etc…


Below is the result when the volume DID NOT FIND any dbbackup volumes:
---
C:\Program Files\Tivoli\TSM\server>dsmserv display dbbackupvolume devc=ltoclass
volumenames=001394
ANR0900I Processing options file c:\program files\tivoli\tsm\server1\dsmserv.o-
pt.
ANR7800I DSMSERV generated at 08:35:01 on Jul 24 2008.

Tivoli Storage Manager for Windows
Version 5, Release 5, Level 1.0

Licensed Materials - Property of IBM

(C) Copyright IBM Corporation 1990, 2007.
All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.

ANR4726I The ICC support module has been loaded.
ANR8200I TCP/IP Version 4 driver ready for connection with clients on port
1500.
ANR8302E I/O error on drive DRIVE1 (mt2.0.0.2) with volume (OP=OFFL, Error
Number=21, CC=0, KEY=02, ASC=04, ASCQ=02,
SENSE=70.00.02.00.00.00.00.1C.00.00.-
00.00.04.02.00.00.10.12.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.02,
De-
scription=An undetermined error has occurred). Refer to Appendix C in the
'Messages' manual for recommended action.
ANR8358E Audit operation is required for library L40.
ANR8337I LTO volume 001394 mounted in drive DRIVE1 (mt2.0.0.2).
ANR1363I Input volume 001394 opened (sequence number 1397048914).
ANR1364I Input volume 001394 closed.
Entering exception handler.
Leaving exception handler.
---
regardless after that…it goes back to the command prompt

So I was able to restore the db, once I found the most recent dbbackup, after manually going through the volumes one by one…
of course the other method, would have been to try to use a batch/script file and have it go through the vollist.txt with all the volumes..
but then again because of the error I mentioned above of if not finding something it goes back to the command prompt, I’m not sure if
that would NOT have been the case if I used the batched file…

Hopes this helps for a future case that's similar :)

kim t.
 
Last edited:
Top