dsmserv restore db Command failed - sufficient server database space not avail

[chahar_adsm]

TSM 5.5 is running on Wik 2k3 Server.
yester day log reached 100% and server stopped. Even more one bat file (C:\Tivoli\tsm\server1\initserv.bat) fired by mistake.
As a result a new tsm server instance created with removing old and all pas information - config lost.

The DBVOL, LOGVOL & the DB_Backup copy available.

Trying to restore the server with the command:
dsmserv restore db devclass=fileclass volumename=22177138.dbb

But it didn't succeed. Output of the above command is as follow:

(ANR0900I Processing options file C:\Tivoli\TSM\server1\dsmserv.opt.
ANR7800I DSMSERV generated at 11:22:47 on Nov 8 2007.

Tivoli Storage Manager for Windows Version 5, Release 5, Level 0.0

Licensed Materials - Property of IBM

(C) Copyright IBM Corporation 1990, 2007. All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.

ANR4726I The ICC support module has been loaded.
ANR8200I TCP/IP Version 4 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 FILECLASS.
ANR4622I Volume 1: D:\DBBACKUP\22177138.DBB.
ANR4632I Starting point-in-time database restore (no commit).
ANR8340I FILE volume D:\DBBACKUP\22177138.DBB mounted.
ANR1363I Input volume D:\DBBACKUP\22177138.DBB opened (sequence number 1).
ANR4646I Database capacity required for restore is 6144 megabytes.
ANR4647I Database available capacity is 12 megabytes.
ANR1364I Input volume D:\DBBACKUP\22177138.DBB closed.
ANR2028E RESTORE DB: Command failed - sufficient server database space is not available.

C:\Tivoli\TSM\server> )

Plz help me out - if any body is havaing any solution.

 

[rore]

Hi chahar_adsm,

ANR4646I Database capacity required for restore is 6144 megabytes.
ANR4647I Database available capacity is 12 megabytes.

You have to create your database volume(s) greather than 6144 megabytes. You have to use the DSMFMT command. It seems that your are trying to restore over the new instance, which by default created a database of 12MB.

Rudy

 

[chahar_adsm]

Hi dear

The actual DB & LOG volume copies are available on my HDD in D Drive, as per initial implementation:

d:\dbvol\dbvol1.dsm
d:\dbvol\dbvol2.dsm
d:\dbvol\dbvol3.dsm **each 2 GB size

d:\logvol\logvol1.dsm * single with 1 GB size

These volume(s) can be use Or I have create to fresh volume(s). If I have to create fresh volume with DSMFMT command then should I rename the above mentioned volume name.?

 

[heada]

When the batch script ran, it created a new DB (12MB) and log (4MB) in the install directory (C:\Program Files\Tivoli\TSM\Server1 by default). You'll need to update TSM to use the old files to restore into. This is normally done by using the dsmfmt command to create the files and then the dsmserv format db command to add them to the dsmserv.dsk file and format the log.

You *might* be able to update the dsmserv.dsk file with the correct file names and locations for your old DB and log, extend the log by 4MB and then restart TSM without restoring your database. It may or may not work and if you don't know how to do that, you're better off to restore it from tape after formatting the files.

-Aaron

 

[chahar_adsm]

Hi Aaron,

Thnx for quik resp. I will try by updating the dsmserv.dsk file.

Sonu.

 

[chahar_adsm]

Hello dear,

I have started to perform the dsmserv restore db after making the entries in the dsmserv.dsk file with the old information.

I am getting the output as follows. I am not getting the meaning of the entry "ANR0478W Session request refused. Server is running in standalone mode." Can anybody give idea about the this...?


"ANR4726I The ICC support module has been loaded.
ANR8200I TCP/IP Version 4 driver ready for connection with clients on port 1500.
ANR9969E Unable to open volume D:\dbvol\logvol1.dsm. The most likely reason is that
another TSM server is running and has the volume allocated.
ANR0200I Recovery log assigned capacity is 1024 megabytes.
ANR0201I Database assigned capacity is 6144 megabytes.
ANR4621I Database backup device class FILECLASS.
ANR4622I Volume 1: D:\DBBACKUP\22177138.DBB.
ANR4632I Starting point-in-time database restore (no commit).
ANR8340I FILE volume D:\DBBACKUP\22177138.DBB mounted.
ANR1363I Input volume D:\DBBACKUP\22177138.DBB opened (sequence number 1).
ANR4646I Database capacity required for restore is 6144 megabytes.
ANR4638I Restore of backup series 378 operation 0 in progress.
ANR0478W Session request refused. Server is running in standalone mode.
ANR0478W Session request refused. Server is running in standalone mode.
ANR4639I Restored 47424 of 947862 database pages.
ANR0478W Session request refused. Server is running in standalone mode.
ANR4639I Restored 95360 of 947862 database pages.
ANR0478W Session request refused. Server is running in standalone mode.
ANR4639I Restored 140480 of 947862 database pages.
ANR0478W Session request refused. Server is running in standalone mode.
ANR0478W Session request refused. Server is running in standalone mode.
ANR4639I Restored 189312 of 947862 database pages.
ANR0478W Session request refused. Server is running in standalone mode.
ANR0478W Session request refused. Server is running in standalone mode.
ANR0478W Session request refused. Server is running in standalone mode.
ANR0478W Session request refused. Server is running in standalone mode.
ANR0478W Session request refused. Server is running in standalone mode."



- Sonu.

 

[moon-buddy]

ANR0478W Session request refused. Server is running in standalone mode.
ANR0478W Session request refused. Server is running in standalone mode.
ANR0478W Session request refused. Server is running in standalone mode.
ANR0478W Session request refused. Server is running in standalone mode.

A node or nodes is/are trying to connect and cannot do so since you are restoring...

Disable the sessions via dsmserv.opt