Hi

You'¨ll need to do the restore with commit=yes.

Best Regards

Daniel Sparrman
-----------------------------------
Daniel Sparrman
Exist i Stockholm AB
Propellervägen 6B
183 62 TÄBY
Växel: 08 - 754 98 00
Mobil: 070 - 399 27 51



Nghia Tran Dai <NghiaTD2 AT FPT.COM DOT VN> 
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
2004-05-06 10:16
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Error when restoring database of TSM server






Hi all,
I use TSM ver 5.1.7
The database and log file of my TSM server were lost. I backuped database 
(volume history, device configuration file) and now I use them to restore 
database of TSM server. But I get error message when I start "TSM server 
1" service  after restored database successfully.
 
 
I did as following:
 
C:\Program Files\tivoli\tsm\server>dsmserv format 1 
C:\tsmdata\server1\log1.dsm
9 1 C:\tsmdata\server1\db1.dsm 13
ANR0900I Processing options file C:\Program 
Files\tivoli\tsm\server\dsmserv.opt.
ANR7800I DSMSERV generated at 12:02:29 on Aug 21 2002.
Tivoli Storage Manager for Windows
Version 5, Release 1, Level 5.0
Licensed Materials - Property of IBM
5698-ISE (C) Copyright IBM Corporation 1999,2002. All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.
Allocated space for C:\tsmdata\server1\log1.dsm: 9437184 bytes.
Allocated space for C:\tsmdata\server1\db1.dsm: 13631488 bytes.
ANR0300I Recovery log format started; assigned capacity 8 megabytes.
ANR0301I Recovery log format in progress; 4 megabytes of 8.
ANR0301I Recovery log format in progress; 8 megabytes of 8.
ANR0302I Recovery log formatting took 0 milliseconds.
ANR0303I Format rate:     1.$ pages/second.
ANR0304I Page service time:     0.0 ms.
ANR0305I Recovery log format complete.
ANR0306I Recovery log volume mount in progress.
ANR0353I Recovery log analysis pass in progress.
ANR0354I Recovery log redo pass in progress.
ANR0355I Recovery log undo pass in progress.
ANR0352I Transaction recovery complete.
ANR0992I Server installation complete.
 
C:\Program Files\tivoli\tsm\server>dsmserv restore db 
volumenames=C:\tsmdata\ser
ver1\83828523.dbb devclass=filedev1 commit=no
ANR0900I Processing options file c:\program 
files\tivoli\tsm\server1\dsmserv.op-
t.
ANR7800I DSMSERV generated at 12:02:29 on Aug 21 2002.
Tivoli Storage Manager for Windows
Version 5, Release 1, Level 5.0
Licensed Materials - Property of IBM
5698-ISE (C) Copyright IBM Corporation 1999,2002. 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.
ANR0200I Recovery log assigned capacity is 8 megabytes.
ANR0201I Database assigned capacity is 12 megabytes.
ANR4621I Database backup device class FILEDEV1.
ANR4622I   Volume 1: C:\TSMDATA\SERVER1\83828523.DBB.
ANR4632I Starting point-in-time database restore (no commit).
ANR8340I FILE volume C:\TSMDATA\SERVER1\83828523.DBB mounted.
ANR1363I Input volume C:\TSMDATA\SERVER1\83828523.DBB opened (sequence 
number 1).
ANR4646I Database capacity required for restore is 12 megabytes.
ANR4638I Restore of backup series 1 operation 0 in progress.
ANR1364I Input volume C:\TSMDATA\SERVER1\83828523.DBB closed.
ANR4640I Restored 258 pages from backup series 1 operation 0.
ANR4633I Point-in-time database restore (no commit) complete.
 
I don't know how to deal with this problem. Could you help me ?
 
Thanks in advanced,
 
Nghiatd