ADSM-L

Re: DB restore questions

2003-07-07 14:43:00
Subject: Re: DB restore questions
From: Jim Sporer <james.sporer AT DOIT.WISC DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 7 Jul 2003 13:42:41 -0500
Geoff,
Try adding a TODATE= to the RESTORE command.  The manual says the TODATE is
required if you want to do a point in time restore with a volume history
file.  I suspect TSM is trying to read the recovery log to do a roll
forward restore with out the TODATE parameter.
Jim

At 09:43 PM 7/3/2003 -0700, you wrote:
Ok, I'm working on a test to restore the DB on my test server. At the moment
I've hit a wall and wonder if someone can shed some light. The server is an
H50, AIX5.1 TSM 5.1.7, the library is an automated 3494, the drives are
fiber attached 3590's.



I installed AIX5.1, TSM 5.1.7, which is what was on it before. I've
formatted DB and log space. I have the volhist file, devconf, dsmserv.opt
and dsmserv.dsk I saved. I did notice the tape drives came up in a different
order so I changed the devconf file. I decided to fly by night and create DB
and logs with a name I would dream up just in case I was the one who got
whacked and someone else needed to do this without much help. Not sure if
that is an issue.



I put the files back where they belong, the library is available because
mtlib commands work. The question is why do I get this output when trying to
restore? I looked up the error and it doesn't make sense because the db is
formatted and there. The size of the file is large enough, 15GB, to restore
a db backup that really has nothing in it except 2 computers I've been
backing up to test.



# dsmserv restore db vol=U01936 dev=3590 commit=YES

ANR7800I DSMSERV generated at 08:09:53 on Jun  4 2003.



Tivoli Storage Manager for AIX-RS/6000

Version 5, Release 1, Level 7.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.



ANR0900I Processing options file dsmserv.opt.

ANR7811I Direct I/O will be used for all eligible disk files.

ANR8200I TCP/IP driver ready for connection with clients on port 1500.

ANR0259E Unable to read complete restart/checkpoint information from any

database or recovery log volume.

Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail:   gillg AT saic DOT com
Phone:  (858) 826-4062
Pager:   (877) 905-7154

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