On Thu, 6 May 2004 10:27:58 +0200
Daniel Sparrman <Daniel.Sparrman AT EXIST DOT SE> wrote:

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

Actually, in the TSM administrators guide, the example given is unclear on
that, while the reference guide does mention that the last restore should be
performed with commit=y. Maybe the administrators guide should be fixed to
give a complete example.

> 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
>  


-- 
Met vriendelijke groeten,

Remco Post

SARA - Reken- en Netwerkdiensten                      http://www.sara.nl
High Performance Computing  Tel. +31 20 592 3000    Fax. +31 20 668 3167

"I really didn't foresee the Internet. But then, neither did the computer
industry. Not that that tells us very much of course - the computer industry
didn't even foresee that the century was going to end." -- Douglas Adams