a problem of restore tsm db

[ziven]

i'm doing a test of restore the tsm db:

log mode:rollforward,

1,halt the server

2,backup the tsm db to another directory(for security)

3,destoryed the content of the tsm db

4,run the command :grin:smserv restore db

then ,it failed ,and the report is as following:





ANR0900I Processing options file C:\Program Files\Tivoli\TSM\server\dsmserv.opt.

ANR7800I DSMSERV generated at 13:07:10 on Apr 8 2004.



Tivoli Storage Manager for Windows

Version 5, Release 2, Level 2.4



****************************************************************

* Patch 5.2.2.4 TSM Server (Driver 0000, Build 04099.1307) *

* This is a server interim fix based on certified service *

* fixpack level 5.2.2.0 and has not been fully tested. List of *

* fixes made can be found in the README *

* *

****************************************************************

Licensed Materials - Property of IBM



(C) Copyright IBM Corporation 1990,2003. All rights reserved.

U.S. Government Users Restricted Rights - Use, duplication or disclosure

restricted by GSA ADP Schedule Contract with IBM Corporation.



ANR8200I TCP/IP driver ready for connection with clients on port 1500.

ANR9999D lvminit.c(1915): ThreadId<0> The capacity of disk 'E:\TSMDATA\SERVER1-

\DBVOL2.DSM' has changed; old capacity 13568 - new capacity 13309.

Callchain of

previous message: 77E8BBF3 RaiseException()+56 <- 1000F969 tsmInitializeServ-

er()+8139 <- 104E58D9 outTextf()+1469 <- 102A90FD tsmInitializeServer()+2A18-

CD <-

ANR9999D lvminit.c(1671): ThreadId<0> Unable to add disk E:\TSMDATA\SERVER1\DB-

VOL2.DSM to disk table.

Callchain of previous message: 77E8BBF3 RaiseExceptio-

n()+56 <- 1000F969 tsmInitializeServer()+8139 <- 104E58D9 outTextf()+1469 <-

102A9DEA tsmInitializeServer()+2A25BA <-

ANR0259E Unable to read complete restart/checkpoint information from any

database or recovery log volume.

Entering exception handler.









I don't know how to solve it.because if i didn't change the capacity of the db file,i restoed

the server successfully.but ,if the server is really crashed,i think the content of the db would be most likely destroyed and the capacity would be changed too.



could anyone will tell me the reason and the ways to solve it.



thank you very much!

best regards!

 

[Harry_Redl]

Hi,

how did you "destroyed the content of the tsm db" ?



If your db backup is OK, you can restore it do different db volumes than it was before crash. delete your dsmserv.dsk file (back it up for sure) and create new db and rlog files using dsmfmt utility

example:

dsmfmt -m -log <path>dsm.log 300 (300 MB file)

dsmfmt -g -db <path>dsm.db1 4 (4 GB File)

it will update your new dsmserv.dsk file (look into it to see)



then you can restore your db using dsmserv restoredb command to the new volumes (no matter how big the original volumes were - unles you do not have space enough )



This worked for me under linux, so I assume it will work under Windows as well



Hope it helps

Harry

 

[ziven]

<TABLE BORDER=0 ALIGN=CENTER WIDTH=85%><TR><TD><font class="pn-sub">Quote:</font><HR></TD></TR><TR><TD><FONT class="pn-sub"><BLOCKQUOTE>Hi,

how did you "destroyed the content of the tsm db" ?



If your db backup is OK, you can restore it do different db volumes than it was before crash. delete your dsmserv.dsk file (back it up for sure) and create new db and rlog files using dsmfmt utility

example:

dsmfmt -m -log &lt;path>dsm.log 300 (300 MB file)

dsmfmt -g -db &lt;path>dsm.db1 4 (4 GB File)

it will update your new dsmserv.dsk file (look into it to see)



then you can restore your db using dsmserv restoredb command to the new volumes (no matter how big the original volumes were - unles you do not have space enough )



This worked for me under linux, so I assume it will work under Windows as well



Hope it helps

Harry</BLOCKQUOTE></FONT></TD></TR><TR><TD><HR></TD></TR></TABLE>



thank you!

I have done the test as you said.

now ,i'm doing another:

I destroyed the dbvol by a tool---ultraEdit

I have set the log mode as ROLLFORWARD,

but when i restored ,there occurred an error as i told.

I don't know why

 

[Harry_Redl]

Hi,

it seems to me you were just "lucky" and destroyed that part of TSM DB volume which describes it (DB volume consist of 4M blocks of real data and 1M block of database volume information)

Have you got the same error when you destroy the DB content another way? For example when you have two identical (in size and location) db volumes and swith their names?



Hope it helps



Harry



P.S. If the restore works using another volumes, do not bother with the old ones ... IMHO it is better to delete the DB volumes and create them again to be sure there is no disk error ....