ADSM-L

Re: Fw: Restore DB without effect

2006-05-08 18:00:56
Subject: Re: Fw: Restore DB without effect
From: Andrew Raibeck <storman AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 8 May 2006 15:03:42 -0700
Raibeck's Rule #19: "Do not fear the Messages manual."

and it's corollary:

"Do not fear the built-in help facilities."

The Messages manual entry for ANR4633I contains a hint for the solution to
this question. Or (when you TSM server is available) you can do this from
the admin command line interface:

   HELP ANR4633I

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

IBM Tivoli Storage Manager support web page:
http://www-306.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2006-05-08
14:29:49:

> 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

<Prev in Thread] Current Thread [Next in Thread>