DB2 Redirected Restore

[cerbdog@gmail.com]

Hello, all. Was hoping someone might be able to help us out with an
issue:

We're trying to perform a restore from a backup of one AIX 5.1 server,
we'll call it "AIX", to another AIX 5.1 server; we'll call this one
"DEV". We're using Netbackup 5.1 MP3 to do this. For some reason when
we try to restore from AIX's backup to DEV we recieve an error from
Netbackup that states:
_______________ _______________ ______________
+ db2 restore database (instance) load
/usr/openv/netbackup/bin/nbdb2.sl64 OPEN 4 SESSIONS BUFFER 1024
SQL2025N An I/O error "515" occurred on media "VENDOR".
_______________ _______________ ______________

Veritas people don't seem to know what's going on with this one, nor do
IBM. Any help would be terrific.

[Ian]

Re: DB2 Redirected Restore

cerbdog@gmail.c om wrote:[color=blue]
> Hello, all. Was hoping someone might be able to help us out with an
> issue:
>
> We're trying to perform a restore from a backup of one AIX 5.1 server,
> we'll call it "AIX", to another AIX 5.1 server; we'll call this one
> "DEV". We're using Netbackup 5.1 MP3 to do this. For some reason when
> we try to restore from AIX's backup to DEV we recieve an error from
> Netbackup that states:
> _______________ _______________ ______________
> + db2 restore database (instance) load
> /usr/openv/netbackup/bin/nbdb2.sl64 OPEN 4 SESSIONS BUFFER 1024
> SQL2025N An I/O error "515" occurred on media "VENDOR".
> _______________ _______________ ______________[/color]

The NetBackup for DB2 agent does not have the ability to restore a
backup taken from server A and restore it on server B. We talked
to Veritas about this, and the engineers responded with, "why would
you need to do that?" There isn't even a way to extract the backup
image from NetBackup to a filesystem.

We tried to work around this by modifying the CLIENT_NAME in bp.conf
on the "target" machine, but were unable get anything to work because
the UID for the DB2 instance owners was different on the source/target
servers. Theoretically if you have the same UID for the instances on
both servers you might be able to fake out NetBackup.


FYI, error "515" in NetBackup means that it can't find the object to
restore.

[cerbdog@gmail.com]

Re: DB2 Redirected Restore


Ian wrote:[color=blue]
> cerbdog@gmail.c om wrote:[color=green]
> > Hello, all. Was hoping someone might be able to help us out with an
> > issue:
> >
> > We're trying to perform a restore from a backup of one AIX 5.1 server,
> > we'll call it "AIX", to another AIX 5.1 server; we'll call this one
> > "DEV". We're using Netbackup 5.1 MP3 to do this. For some reason when
> > we try to restore from AIX's backup to DEV we recieve an error from
> > Netbackup that states:
> > _______________ _______________ ______________
> > + db2 restore database (instance) load
> > /usr/openv/netbackup/bin/nbdb2.sl64 OPEN 4 SESSIONS BUFFER 1024
> > SQL2025N An I/O error "515" occurred on media "VENDOR".
> > _______________ _______________ ______________[/color]
>
> The NetBackup for DB2 agent does not have the ability to restore a
> backup taken from server A and restore it on server B. We talked
> to Veritas about this, and the engineers responded with, "why would
> you need to do that?" There isn't even a way to extract the backup
> image from NetBackup to a filesystem.
>
> We tried to work around this by modifying the CLIENT_NAME in bp.conf
> on the "target" machine, but were unable get anything to work because
> the UID for the DB2 instance owners was different on the source/target
> servers. Theoretically if you have the same UID for the instances on
> both servers you might be able to fake out NetBackup.
>
>
> FYI, error "515" in NetBackup means that it can't find the object to
> restore.[/color]



We were able to get this working, but I was not around when they did
it, so I'll have to check and see how exactly they managed it. All I
caught in passing was that it had to do with editing the bp.conf file.
Seems strange to do something like this, but the basic reason was that
the server the data was backed up from was under repair and they needed
to access that data ASAP, so we decided just to put it on another
server. Thanks for the response, I may post what exactly they did when
I get a bit of time and find out, so maybe someone else can refrence it
later.

[Anurag]

Re: DB2 Redirected Restore

Hi,
My experience worth 2 cents:
For 2 servers to see each others backup / restore IS POSSIBLE.
It boils down to how competent your VERITAS guys are.

Well, I am a DB2 UDB DBA who had the good fortune to have worked with a
person with good hokd on VERITAS BACKUP config.
When we were facing similar problems, he created 2 files in directory
"/usr/openv/netbackup/db/altnames".

Specific to your scenario, these files would be named "aix.<full dns
name>" and "dev.<full dns name>".
"aix.<full dns name>" would contain a single line entry for "dev.<full
dns name>" and similarly for the other file.

I know I may not be very exact in providing the solution (BUT I AM NOT
A VERITAS PERSON :);
But - IF YOU HAVE A GOOD VERITAS GUY, THIS IS POSSIBLE.

..........Anura g