DB2 Redirected Restore

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cerbdog@gmail.com - 23 Mar 2006 15:57 GMT

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.

Reply to this Message

Ian - 23 Mar 2006 23:31 GMT

> Hello, all. Was hoping someone might be able to help us out with an
> issue:
[quoted text clipped - 9 lines]
> SQL2025N An I/O error "515" occurred on media "VENDOR".
> ____________________________________________

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.

Reply to this Message

cerbdog@gmail.com - 26 Mar 2006 03:05 GMT

> > Hello, all. Was hoping someone might be able to help us out with an
> > issue:
[quoted text clipped - 24 lines]
> FYI, error "515" in NetBackup means that it can't find the object to
> restore.

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.

Reply to this Message

Anurag - 31 Mar 2006 12:56 GMT

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.

.........Anurag

Reply to this Message