Re: Restore DB without effect

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