Fw: Restore DB without effect

As others have said, you're missing the "commit=yes" at the end of the
restore command.

Nick Cassimatis
email: nickpc AT us.ibm DOT com

----- Forwarded by Nicholas Cassimatis/Raleigh/IBM on 05/08/2006 05:29 PM
-----

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 05/08/2006
04:52:38 PM:

> Wiadomosc przeskanowana programem antywirusowym. Nie znaleziono wirusow /
> This message was anti-virus scanned. No viruses were found.
> This is what I used, but before I used the same restore comman from
> devclass LTO
> :
> C:\Program Files\Tivoli\tsm\server>dsmserv restore db devclass=dbbclass
> volumena
> mes=11278522.dbb,11278618.dbb,11278702.dbb,11278791.dbb,11278882.
> dbb,11278968.db
> b,11279042.dbb,11279113.dbb,11279182.dbb
> ANR0900I Processing options file C:\Program
> Files\Tivoli\tsm\server\dsmserv.op-
> t.
> ANR7800I DSMSERV generated at 16:50:40 on Jun 21 2004.
>
> Tivoli Storage Manager for Windows
> Version 5, Release 2, Level 3.0
>
> 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.
> ANR0200I Recovery log assigned capacity is 10024 megabytes.
> ANR0201I Database assigned capacity is 40096 megabytes.
> ANR4621I Database backup device class DBBCLASS.
> ANR4622I   Volume 1: G:\TSM\DB_BACKUP\11278522.DBB.
> ANR4622I   Volume 2: G:\TSM\DB_BACKUP\11278618.DBB.
> ANR4622I   Volume 3: G:\TSM\DB_BACKUP\11278702.DBB.
> ANR4622I   Volume 4: G:\TSM\DB_BACKUP\11278791.DBB.
> ANR4622I   Volume 5: G:\TSM\DB_BACKUP\11278882.DBB.
> ANR4622I   Volume 6: G:\TSM\DB_BACKUP\11278968.DBB.
> ANR4622I   Volume 7: G:\TSM\DB_BACKUP\11279042.DBB.
> ANR4622I   Volume 8: G:\TSM\DB_BACKUP\11279113.DBB.
> ANR4622I   Volume 9: G:\TSM\DB_BACKUP\11279182.DBB.
> ANR4632I Starting point-in-time database restore (no commit).
> ANR8340I FILE volume G:\TSM\DB_BACKUP\11278522.DBB mounted.
> ANR1363I Input volume G:\TSM\DB_BACKUP\11278522.DBB opened (sequence
number
> 1).A
> NR4646I Database capacity required for restore is 12440 megabytes.
> ANR4649I Reducing database assigned capacity to 12440 megabytes.
> ANR4638I Restore of backup series 230 operation 0 in progress.
> ANR1365I Volume G:\TSM\DB_BACKUP\11278522.DBB closed (end reached).
> ANR8340I FILE volume G:\TSM\DB_BACKUP\11278618.DBB mounted.
> ANR1363I Input volume G:\TSM\DB_BACKUP\11278618.DBB opened (sequence
number
> 2).A
> NR4639I Restored 381952 of 2124324 database pages.
> ANR1365I Volume G:\TSM\DB_BACKUP\11278618.DBB closed (end reached).
> ANR8340I FILE volume G:\TSM\DB_BACKUP\11278702.DBB mounted.
> ANR1363I Input volume G:\TSM\DB_BACKUP\11278702.DBB opened (sequence
number
> 3).A
> NR1365I Volume G:\TSM\DB_BACKUP\11278702.DBB closed (end reached).
> ANR8340I FILE volume G:\TSM\DB_BACKUP\11278791.DBB mounted.
> ANR1363I Input volume G:\TSM\DB_BACKUP\11278791.DBB opened (sequence
number
> 4).A
> NR4639I Restored 771200 of 2124324 database pages.
> ANR1365I Volume G:\TSM\DB_BACKUP\11278791.DBB closed (end reached).
> ANR8340I FILE volume G:\TSM\DB_BACKUP\11278882.DBB mounted.
> ANR1363I Input volume G:\TSM\DB_BACKUP\11278882.DBB opened (sequence
number
> 5).A
> NR4639I Restored 1171456 of 2124324 database pages.
> ANR1365I Volume G:\TSM\DB_BACKUP\11278882.DBB closed (end reached).
> ANR8340I FILE volume G:\TSM\DB_BACKUP\11278968.DBB mounted.
> ANR1363I Input volume G:\TSM\DB_BACKUP\11278968.DBB opened (sequence
number
> 6).A
> NR1365I Volume G:\TSM\DB_BACKUP\11278968.DBB closed (end reached).
> ANR8340I FILE volume G:\TSM\DB_BACKUP\11279042.DBB mounted.
> ANR1363I Input volume G:\TSM\DB_BACKUP\11279042.DBB opened (sequence
number
> 7).A
> NR4639I Restored 1568960 of 2124324 database pages.
> ANR1365I Volume G:\TSM\DB_BACKUP\11279042.DBB closed (end reached).
> ANR8340I FILE volume G:\TSM\DB_BACKUP\11279113.DBB mounted.
> ANR1363I Input volume G:\TSM\DB_BACKUP\11279113.DBB opened (sequence
number
> 8).A
> NR4639I Restored 1964928 of 2124324 database pages.
> ANR1365I Volume G:\TSM\DB_BACKUP\11279113.DBB closed (end reached).
> ANR8340I FILE volume G:\TSM\DB_BACKUP\11279182.DBB mounted.
> ANR1363I Input volume G:\TSM\DB_BACKUP\11279182.DBB opened (sequence
number
> 9).A
> NR1364I Input volume G:\TSM\DB_BACKUP\11279182.DBB closed.
> ANR4640I Restored 2124324 pages from backup series 230 operation 0.
> ANR4633I Point-in-time database restore (no commit) complete.
>
>
> Regarding
> Szymon Kacprzak
>
>
>
>
>              Orville Lantto
>              <orville.lantto@G
>              LASSHOUSE.COM>
To
>              Sent by: "ADSM:           ADSM-L AT VM.MARIST DOT EDU
>              Dist Stor
cc
>              Manager"
>              <[email protected]
Subject
>              .EDU>                     Re: [ADSM-L] Restore DB without
>                                        effect
>
>              2006-05-08 21:04
>
>
>              Please respond to
>              "ADSM: Dist Stor
>                  Manager"
>              <[email protected]
>                    .EDU>
>
>
>
>
>
>
>
>
> Wiadomosc przeskanowana programem antywirusowym. Nie znaleziono wirusow /
> This message was anti-virus scanned. No viruses were found.
> What command did you use to restore the database?
>
> Orville Lantto
> Glasshouse Technologies, Inc.
>
>
> ________________________________
>
> From: ADSM: Dist Stor Manager on behalf of Richard Mochnaczewski
> Sent: Mon 5/8/2006 1:28 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] Restore DB without effect
>
>
>
> Increase your recovery log. It looks like you did not assign enough
space.
>
> Rich
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Szymon Kacprzak
> Sent: Monday, May 08, 2006 1:42 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: [ADSM-L] Restore DB without effect
>
>
> Wiadomosc przeskanowana programem antywirusowym. Nie znaleziono wirusow /
> This message was anti-virus scanned. No viruses were found.
> Hello
>
> After disaster on my TSM Server I've installed on new machine new TSM
> server, copied device configuration and volume history file.
> I've created new db and log with enough space for db and log.
> I run the restore db from tape (actual db backup) and from disk (earlier
db
> backup). For both restoration I've the same result:
>
> C:\Program Files\Tivoli\tsm\server>dsmserv
> ANR0900I Processing options file C:\Program
> Files\Tivoli\tsm\server\dsmserv.opt.
> ANR7800I DSMSERV generated at 16:50:40 on Jun 21 2004.
>
> Tivoli Storage Manager for Windows
> Version 5, Release 2, Level 3.0
>
> 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.
>
> ANR0990I Server restart-recovery in progress.
> ANR0200I Recovery log assigned capacity is 10024 megabytes.
> ANR0201I Database assigned capacity is 12440 megabytes.
> ANR0981E The server database must be restored before the server can be
> started.
>
> What can I do? What could be wrong?
>
> Regarding
>  Szymon Kacprzak