Re: URGENT ? ABOUT DB RESTORE
I assume you do not have a functional adsm server and that is why you are restoring the db, so you cannot do a move media or checkin but you don't need to do that. As long as you have a current volume history file, device configuration file and the tape has been inserted in the atl, you can issue the restore db command that Ruddy gave you and adsm will find the proper tape. Jim Sporer At 07:07 PM 2/22/2001 +0200, you wrote: >No arguments to give. > >If your volhist is still present and not corrupted, if you tape has been >moved back via MOVE MEDIA and if your tape has been checked in, just >type: > >dsmserv restore db todate=xx:xx: totime=xx:xx > >and the TSM server will use the volume corresponding to the tape just >back from off-site. > >Ruddy > >-Original Message- >From: Steve Hicks [mailto:[EMAIL PROTECTED]] >Sent: jeudi 22 février 2001 17:35 >To: [EMAIL PROTECTED] >Subject: Re: URGENT ? ABOUT DB RESTORE > > >What would the syntax be? dsmserv restore db ... >I've tried dsmserv restore db movemedia=6239 and I get and invalid >argument >error. > > > > > > Ruddy STOUDER > > [EMAIL PROTECTED] > SLINK.COM> cc: > > Sent by: "ADSM: Subject: Re: URGENT ? >ABOUT DB RESTORE > Dist Stor Manager" > > <[EMAIL PROTECTED] > > EDU> > > > > > > 02/22/01 11:23 AM > > Please respond to > > "ADSM: Dist Stor > > Manager" > > > > > > > > >tRY / > >1) MOVE MEDIA ... To bring the tape back on-site in the TSM database >2) CHECKIN ... STATUS=PRIVATE to get the tape back in the library > >Ruddy > >-Original Message- >From: Steve Hicks [mailto:[EMAIL PROTECTED]] >Sent: jeudi 22 février 2001 17:11 >To: [EMAIL PROTECTED] >Subject: URGENT ? ABOUT DB RESTORE > > >Need to restore out TSM database but the volume that the DB backup in on >is >listed as VAULT. I have the tape in the automated library, how do I >check >it in to restore from it??
Re: URGENT ? ABOUT DB RESTORE
Steve, you don't need to check in the db tape. Since the tape is in the library, make sure that the devconfig file and the dsmserv.dsk are present in the TSM installed path: and then issue the following command from the OS prompt: dsmserv restore db volumename= devclass= commit= todate... ... You can acces the manual online: http://www.tivoli.com/support/storage_mgr/pubs/v4pubs/v1_html/aix/guide/anratfrm.htm Part#5, Chapter#21 and see what type of restore do you need, and customize the above command according to your environment and needs. If u r using DRM and the prepare command, then find the last prepare file and follow it thru... GLuck. Othonas > -Original Message- > From: Steve Hicks [mailto:[EMAIL PROTECTED]] > Sent: jeudi 22 février 2001 17:11 > To: [EMAIL PROTECTED] > Subject: URGENT ? ABOUT DB RESTORE > > Need to restore out TSM database but the volume that the DB backup in on > is > listed as VAULT. I have the tape in the automated library, how do I > check > it in to restore from it??
Re: URGENT ? ABOUT DB RESTORE
The problem isn't the fact that the volume is marked as VAULT, but rather
that the library can't find it during the restore operation.
Here's what I do:
Ensure that the volhist.out and devconfig.out files are in the right place.
Edit the devconfig.out file.
Notice at the bottom of this file a library inventory. Also notice that the
db backup tape in your hand is not listed in this inventory. Further notice
that dsmserv restore db does not do an audit library. So all it knows about
is the volumes that were in it the last time the devconfig file was written.
Take a tape out of the library and replace it with the db backup tape in
your hand.
Find the entry in the devconfig.out library inventory section and change the
number of the tape you just removed to the number of the tape you just put
in. Now this file believes the db backup tape is in the library.
Open the volhist.out file. Find out the exact date and time of the db
backup on the tape you just put in the library.
Issue the following command:
dsmserv restore db todate=thedate totime=thetime
If you have DRM, look in the planfile for the perfect syntax. If you are
restoring the TSM server in the server1 directory (remember, there can be
multiple instantiations of TSM on a single hardware platform), you need to
be in this directory to do the restore. Your syntax changes slightly to
reflect this: I'll assume NT.
c:>\progra~1\tivoli\tsm\server\dsmserv restore db todate=thedate
totime=thetime
Another way to do this is to edit the devconfig.out file and create a manual
library with one drive in it. Then issue the restore command. This will
cause TSM to prompt you to load the tape in the drive. In some libraries,
this is easy. In some, not so easy. I like the first method the best.
Hope this isn't too late to help.
Thanks,
Kelly J. Lipp
Storage Solutions Specialists, Inc.
PO Box 51313
Colorado Springs CO 80949-1313
(719) 531-5926
Fax: (240) 539-7175
Email: [EMAIL PROTECTED] or [EMAIL PROTECTED]
www.storsol.com
www.storserver.com
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Steve Hicks
Sent: Thursday, February 22, 2001 10:16 AM
To: [EMAIL PROTECTED]
Subject: Re: URGENT ? ABOUT DB RESTORE
Those are some BIG ifs, we don't have the tape checked in and I'm not sure
how to check it in with out getting onto the server. That's the gotcha.
Maybe I'm missing someting though .. please help
Steve
Ruddy STOUDER
cc:
Sent by: "ADSM: Subject: Re: URGENT ?
ABOUT DB RESTORE
Dist Stor Manager"
<[EMAIL PROTECTED]
EDU>
02/22/01 12:07 PM
Please respond to
"ADSM: Dist Stor
Manager"
No arguments to give.
If your volhist is still present and not corrupted, if you tape has been
moved back via MOVE MEDIA and if your tape has been checked in, just
type:
dsmserv restore db todate=xx:xx: totime=xx:xx
and the TSM server will use the volume corresponding to the tape just
back from off-site.
Ruddy
-Original Message-
From: Steve Hicks [mailto:[EMAIL PROTECTED]]
Sent: jeudi 22 fivrier 2001 17:35
To: [EMAIL PROTECTED]
Subject: Re: URGENT ? ABOUT DB RESTORE
What would the syntax be? dsmserv restore db ...
I've tried dsmserv restore db movemedia=6239 and I get and invalid
argument
error.
Ruddy STOUDER
cc:
Sent by: "ADSM: Subject: Re: URGENT ?
ABOUT DB RESTORE
Dist Stor Manager"
<[EMAIL PROTECTED]
EDU>
02/22/01 11:23 AM
Please respond to
"ADSM: Dist Stor
Manager"
tRY /
1) MOVE MEDIA ... To bring the tape back on-site in the TSM database
2) CHECKIN ... STATUS=PRIVATE to get the tape back in the library
Ruddy
-Original Message-
From: Steve Hicks [mailto:[EMAIL PROTECTED]]
Sent: jeudi 22 fivrier 2001 17:11
To: [EMAIL PROTECTED]
Subject: URGENT ? ABOUT DB RESTORE
Need to restore out TSM database but the volume that the DB backup in on
is
listed as VAULT. I have the tape in the automated library, how do I
check
it in to restore from it??
Re: URGENT ? ABOUT DB RESTORE
I think (I hope) that this should not be a problem.
Indeed, first, I thought you needed to restore a db but that your server
was still up and running to do the move media and the checkin.
Obviously, this is not the case.
Anyway, the restore db (a the DOS prompt) is just using the volhist file
to know what is the last available Database Backup.
I am almost sure that your last database backup, on-site or off-site is
declared in the volhist file.
run DSMSERV DISPLAY DBVOLUMES to verify if TSM is aware about it.
So, using restore db will not take care about the fact that the tape is
on-site or off-site but will just send a request to the library to read
it.
SO, just insert your tape in the library and type :
dsmserv restore db todate=xx:xx: totime=xx:xx
or, if the tape is unknown in your volhist file:
dsmserv restore db volumenames= todate=xx:xx: totime=xx:xx
Ruddy
-Original Message-
From: Steve Hicks [mailto:[EMAIL PROTECTED]]
Sent: jeudi 22 février 2001 18:16
To: [EMAIL PROTECTED]
Subject: Re: URGENT ? ABOUT DB RESTORE
Those are some BIG ifs, we don't have the tape checked in and I'm not
sure
how to check it in with out getting onto the server. That's the gotcha.
Maybe I'm missing someting though .. please help
Steve
Ruddy STOUDER
cc:
Sent by: "ADSM: Subject: Re: URGENT ?
ABOUT DB RESTORE
Dist Stor Manager"
<[EMAIL PROTECTED]
EDU>
02/22/01 12:07 PM
Please respond to
"ADSM: Dist Stor
Manager"
No arguments to give.
If your volhist is still present and not corrupted, if you tape has been
moved back via MOVE MEDIA and if your tape has been checked in, just
type:
dsmserv restore db todate=xx:xx: totime=xx:xx
and the TSM server will use the volume corresponding to the tape just
back from off-site.
Ruddy
-Original Message-
From: Steve Hicks [mailto:[EMAIL PROTECTED]]
Sent: jeudi 22 février 2001 17:35
To: [EMAIL PROTECTED]
Subject: Re: URGENT ? ABOUT DB RESTORE
What would the syntax be? dsmserv restore db ...
I've tried dsmserv restore db movemedia=6239 and I get and invalid
argument
error.
Ruddy STOUDER
cc:
Sent by: "ADSM: Subject: Re: URGENT ?
ABOUT DB RESTORE
Dist Stor Manager"
<[EMAIL PROTECTED]
EDU>
02/22/01 11:23 AM
Please respond to
"ADSM: Dist Stor
Manager"
tRY /
1) MOVE MEDIA ... To bring the tape back on-site in the TSM database
2) CHECKIN ... STATUS=PRIVATE to get the tape back in the library
Ruddy
-Original Message-
From: Steve Hicks [mailto:[EMAIL PROTECTED]]
Sent: jeudi 22 février 2001 17:11
To: [EMAIL PROTECTED]
Subject: URGENT ? ABOUT DB RESTORE
Need to restore out TSM database but the volume that the DB backup in on
is
listed as VAULT. I have the tape in the automated library, how do I
check
it in to restore from it??
Re: URGENT ? ABOUT DB RESTORE
Those are some BIG ifs, we don't have the tape checked in and I'm not sure
how to check it in with out getting onto the server. That's the gotcha.
Maybe I'm missing someting though .. please help
Steve
Ruddy STOUDER
cc:
Sent by: "ADSM: Subject: Re: URGENT ? ABOUT DB
RESTORE
Dist Stor Manager"
<[EMAIL PROTECTED]
EDU>
02/22/01 12:07 PM
Please respond to
"ADSM: Dist Stor
Manager"
No arguments to give.
If your volhist is still present and not corrupted, if you tape has been
moved back via MOVE MEDIA and if your tape has been checked in, just
type:
dsmserv restore db todate=xx:xx: totime=xx:xx
and the TSM server will use the volume corresponding to the tape just
back from off-site.
Ruddy
-Original Message-
From: Steve Hicks [mailto:[EMAIL PROTECTED]]
Sent: jeudi 22 février 2001 17:35
To: [EMAIL PROTECTED]
Subject: Re: URGENT ? ABOUT DB RESTORE
What would the syntax be? dsmserv restore db ...
I've tried dsmserv restore db movemedia=6239 and I get and invalid
argument
error.
Ruddy STOUDER
cc:
Sent by: "ADSM: Subject: Re: URGENT ?
ABOUT DB RESTORE
Dist Stor Manager"
<[EMAIL PROTECTED]
EDU>
02/22/01 11:23 AM
Please respond to
"ADSM: Dist Stor
Manager"
tRY /
1) MOVE MEDIA ... To bring the tape back on-site in the TSM database
2) CHECKIN ... STATUS=PRIVATE to get the tape back in the library
Ruddy
-Original Message-
From: Steve Hicks [mailto:[EMAIL PROTECTED]]
Sent: jeudi 22 février 2001 17:11
To: [EMAIL PROTECTED]
Subject: URGENT ? ABOUT DB RESTORE
Need to restore out TSM database but the volume that the DB backup in on
is
listed as VAULT. I have the tape in the automated library, how do I
check
it in to restore from it??
Re: URGENT ? ABOUT DB RESTORE
No arguments to give. If your volhist is still present and not corrupted, if you tape has been moved back via MOVE MEDIA and if your tape has been checked in, just type: dsmserv restore db todate=xx:xx: totime=xx:xx and the TSM server will use the volume corresponding to the tape just back from off-site. Ruddy -Original Message- From: Steve Hicks [mailto:[EMAIL PROTECTED]] Sent: jeudi 22 février 2001 17:35 To: [EMAIL PROTECTED] Subject: Re: URGENT ? ABOUT DB RESTORE What would the syntax be? dsmserv restore db ... I've tried dsmserv restore db movemedia=6239 and I get and invalid argument error. Ruddy STOUDER cc: Sent by: "ADSM: Subject: Re: URGENT ? ABOUT DB RESTORE Dist Stor Manager" <[EMAIL PROTECTED] EDU> 02/22/01 11:23 AM Please respond to "ADSM: Dist Stor Manager" tRY / 1) MOVE MEDIA ... To bring the tape back on-site in the TSM database 2) CHECKIN ... STATUS=PRIVATE to get the tape back in the library Ruddy -Original Message- From: Steve Hicks [mailto:[EMAIL PROTECTED]] Sent: jeudi 22 février 2001 17:11 To: [EMAIL PROTECTED] Subject: URGENT ? ABOUT DB RESTORE Need to restore out TSM database but the volume that the DB backup in on is listed as VAULT. I have the tape in the automated library, how do I check it in to restore from it??
Re: URGENT ? ABOUT DB RESTORE
What would the syntax be? dsmserv restore db ... I've tried dsmserv restore db movemedia=6239 and I get and invalid argument error. Ruddy STOUDER cc: Sent by: "ADSM: Subject: Re: URGENT ? ABOUT DB RESTORE Dist Stor Manager" <[EMAIL PROTECTED] EDU> 02/22/01 11:23 AM Please respond to "ADSM: Dist Stor Manager" tRY / 1) MOVE MEDIA ... To bring the tape back on-site in the TSM database 2) CHECKIN ... STATUS=PRIVATE to get the tape back in the library Ruddy -Original Message- From: Steve Hicks [mailto:[EMAIL PROTECTED]] Sent: jeudi 22 février 2001 17:11 To: [EMAIL PROTECTED] Subject: URGENT ? ABOUT DB RESTORE Need to restore out TSM database but the volume that the DB backup in on is listed as VAULT. I have the tape in the automated library, how do I check it in to restore from it??
Re: URGENT ? ABOUT DB RESTORE
tRY / 1) MOVE MEDIA ... To bring the tape back on-site in the TSM database 2) CHECKIN ... STATUS=PRIVATE to get the tape back in the library Ruddy -Original Message- From: Steve Hicks [mailto:[EMAIL PROTECTED]] Sent: jeudi 22 février 2001 17:11 To: [EMAIL PROTECTED] Subject: URGENT ? ABOUT DB RESTORE Need to restore out TSM database but the volume that the DB backup in on is listed as VAULT. I have the tape in the automated library, how do I check it in to restore from it??
URGENT ? ABOUT DB RESTORE
Need to restore out TSM database but the volume that the DB backup in on is listed as VAULT. I have the tape in the automated library, how do I check it in to restore from it??
