ADSM-L

Re: Taking dbbackups on remote TSM servers

2004-05-06 09:00:27
Subject: Re: Taking dbbackups on remote TSM servers
From: Remco Post <r.post AT SARA DOT NL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 6 May 2004 14:54:45 +0200
On Thu, 6 May 2004 18:01:56 +0530
Anoop Das <danoop AT IN.IBM DOT COM> wrote:


> Alex, the "restore dbbackup" command requires that the the dbbackup
> volume be listed in the volhist file. Once the dbbackup from disk is
> backed up

Not true, the dbbackup can be anywhere, as long as the devclass is
defined in your devconfig backup.

> onto tape using dd or tar, I can add this tape volser into the volhist
> file. But how will the "restore dbbackup" command recognise the format
> written in the tape. Also  as I know, dbbackup restore mandates the
> availability of the dbbackup on the catridge.

What you do want to do is make sure that you do have a local dbbackup as
well as a remote backup, so you can recover your server even if the
remote server is unavailable for some reason.

>
> Thanks and Regards
>
> Anoop T.Das
>
>
>
>
>                       Alex Paschal
>                       <AlexPaschal@FREIGH        To:
>                       ADSM-L AT VM.MARIST DOT EDU TLINER.COM>
>                       cc: Sent by: "ADSM:            Subject:  Re:
>                       Taking dbbackups on remote TSM servers Dist Stor
>                       Manager"<[email protected]
>                       DU>
>
>
>                       05/06/2004 02:09 AM
>                       Please respond to
>                       "ADSM: Dist Stor
>                       Manager"
>
>
>
>
> Anoop:
>
> Other than server-server virtual volumes, here's a couple other blue
> sky options.
>
> You might consider taking your dbbackup to disk, then move that file
> over your network to the other machine.  nfs, sftp, scp, ttcp, those
> should all work to get your dbbackup file moved.  Then you can just dd
> or tar it onto tape, if you like.
>
> Or you could somehow use iSCSI to serve up the tape drive itself over
> the WAN, but I don't really think that's such a great idea.
>
> The reason I'd use interim disk is our WAN links are pretty small and
> slow, and keeping a mount point tied up for long enough to xfer 80GB
> worth of database, whether it be via server-server or iSCSI, doesn't
> seem to make much sense to me.  And I probably wouldn't use
> server-server for the same reason, I don't need a dbbackup running all
> day and pinning the recovery log.  Of course, your 300KM line could be
> gigabit with LAN level latency, for all I know. <grin>
>
> Alex Paschal
> Freightliner, LLC
> (503) 745-6850 phone/vmail
>
>
> -----Original Message-----
> From: Anoop Das [mailto:danoop AT IN.IBM DOT COM]
> Sent: Wednesday, May 05, 2004 7:56 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Taking dbbackups on remote TSM servers
>
>
> Hi all
>
> I have two TSM servers connected to LTO 3583 located 300 KMs apart and
> the dbabckup for the same happens locally. I then send the dbbackups
> to offsite( Site-A to Site-B and viceversa) on a daily basis.
>
> Is it possible to take the dbbackup of server-A to the site-B drive
> and server-B to the site-A LTO drive?  This will relieve me of the
> manual activity of sending the dbbackup tapes taken locally to offsite
> daily. Also being a scheduled activity there is no chance for
> failures.
>
> Any help is highly appreciated.
>
> Anoop


--
Met vriendelijke groeten,

Remco Post

SARA - Reken- en Netwerkdiensten                      http://www.sara.nl
High Performance Computing  Tel. +31 20 592 3000    Fax. +31 20 668 3167

"I really didn't foresee the Internet. But then, neither did the
computer industry. Not that that tells us very much of course - the
computer industry didn't even foresee that the century was going to
end." -- Douglas Adams