Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

RMAN Restore failing in NBU 6.5.5

Updated: 19 Sep 2010 | 11 comments
Dan Giberson's picture
0 0 Votes
Login to vote
This issue has been solved. See solution.

We are trying to do a RMAN restore and keep getting the following errors:

ORA-19507: failed to retrieve sequential file, handle="1qlkvuhq_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Failed to process backup file <1qlkvuhq_1_1>

Any ideas?

Comments

Marianne van den Berg's picture
10
Aug
2010
0 Votes 0
Login to vote

You need the following logs to troubleshoot:
On Oracle client: dbclient. This log will show connection attempt with master server.
On Master server: bprd. Here you will see incoming request from client.
Following incoming request, you will see master server resolving IP address to hostname that enables a search of catalog for requested backup. Follow this process through bprd and see at which point does the failure occur.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows.
Handy NBU links

Dan Giberson's picture
10
Aug
2010
0 Votes 0
Login to vote

Now comes the embarrasing question....where do I find these logs? On my Oracle box if I go to /usr/openv/netbackup/logs I only have user_ops as a subfolder.

And in my Master server (Windows) I go to Program Files\Netbackup\logs?

Thanks for the help.

NBU 7.01 on Windows 2003 with LTO2 Library

Marianne van den Berg's picture
10
Aug
2010
0 Votes 0
Login to vote

Log directories do not exist by default - you need to create them.
On Master: create bprd folder under Program Files\Netbackup\logs. Restart NBU Request Service to activate log.

On client:
mkdir /usr/openv/netbackup/logs/dbclient
chmod 777 /usr/openv/netbackup/logs/dbclient

(if you don't do the chmod, the oracle user will not have write permission to the folder and backups and restore that would normally be successful will fail due to the lack of write permission to the log dir.)

You will have to retry the restore...

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows.
Handy NBU links

Oddy's picture
11
Aug
2010
0 Votes 0
Login to vote

According to your rman output it sounds like it does not find the backup image on the master server.

Are you restoring to a different client or the same client. If you are restoring to a different client you can use this procedure.

Restore controlfile first
i.e
su - oracle user and run
/usr/openv/netbackup/bin/bplist -C <source client> -t 4 -l -R /
and take a note of the controlfile backup from the date you want to restore from.
If you get a status 135, please
touch /usr/openv/netbackup/db/altnames/No.Restrictions
on the master server and try again.

To Restore connec to Rman on the destination client,
$ORACLE_HOME/bin/rman target / nocatalog

run {
allocate channel ch00 'sbt_tape';
send 'NB_ORA_SERV=<master server>,NB_ORA_CLIENT=<source client>';
restore controlfile to '/tmp/controlfile.ctl' from '<backuppiece for controlfile from bplist output>';
release channel ch00;
}

run {
allocate channel ch00 'sbt_tape';
replicate controlfile from '/tmp/controlfile.ctl' ;
release channel ch00;
}

2.
run {
allocate channel ch00 'sbt_tape';
send NB_ORA_CLIENT=<source client>';
restore database;
recover database;
release channel ch00;
}

alter database open resetlogs;

If you have any problems, create following log directories
on the master
/usr/openv/netbackup/logs/bprd

on the media
/usr/openv/netbackup/logs/bpbrm
/usr/openv/netbackup/logs/bptm

on the client
/usr/openv/netbackup/logs/bpcd
/usr/openv/netbackup/logs/dbclient
change permissions to 777, i,e chmod 777 dbclient

Increase verbose level by adding
VERBOSE = 5
 in the bottom of the /usr/openv/netbackup/bp.conf file.

I hope this helps.

/Oddy

Dan Giberson's picture
12
Aug
2010
0 Votes 0
Login to vote

Oddy,
Our goal will be to restore to a different client, however this test was a direct backup / restore from the same client. I am just in the process of pulling together the log files that I will post.

NBU 7.01 on Windows 2003 with LTO2 Library

wr's picture
11
Aug
2010
0 Votes 0
Login to vote

Oracle RAC?

See this docuument:
http://support.veritas.com/docs/278508

good Will backing-up

Dan Giberson's picture
12
Aug
2010
0 Votes 0
Login to vote

RMAN Logs

I've attached the client and the Master logs....

there is a line in the master logs that says:

bprd: disallowing client restore requests

Is this the cause?

Thanks for your help everyone.

AttachmentSize
master log.txt 19.98 KB
client log.txt 3.18 KB

NBU 7.01 on Windows 2003 with LTO2 Library

wr's picture
12
Aug
2010
1 Vote +1
Login to vote
Manoj Siricilla's picture
12
Aug
2010
0 Votes 0
Login to vote

client restore requests disallowed ?

Paste the output of the following

bpgetconfig | grep -i 'DISALLOW.*RESTORE'
bpclient -client srvycoras18
bpclient -client srvycoras18.XXXXXX.priv

Cheers!
Manoj
------------------
Time isn't running out, but life is...

Marianne van den Berg's picture
12
Aug
2010
0 Votes 0
Login to vote

12:28:15.673 [4612.6352] <2> process_request:   browse_clnt: srvycoras18
12:28:15.673 [4612.6352] <2> process_request:   requesting_clnt: srvycoras18.XXXXXX.priv

12:28:14.626 [1880.6356] <2> hosts_equal: host1 srvycoras18 srvycoras18.XXXXXX.priv addr 10.222.9.24 (0x1809de0a)
12:28:14.626 [1880.6356] <2> hosts_equal: host2 srvycoras18.XXXXXX.priv srvycoras18.XXXXXX.priv addr 10.222.9.24 (0x1809de0a)
12:28:14.626 [1880.6356] <2> hosts_equal: hostnames DO compare (2)

***** EDIT*****
(I should not answer forum posts when I'm tired....)
Hostnames match - no problem there.

You're right - the only problem seems to be this:

client restore requests disallowed

Check Host Properties -> Master -> Client Attributes

Look at the top under Global Attributes to see what is allowed.
Also see in the 'Clients' section if this client is explicitely added and if it has restore limitations.

More details in this TechNote: http://seer.entsupport.symantec.com/docs/278261.htm
and
http://seer.entsupport.symantec.com/docs/319244.htm

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows.
Handy NBU links

Dan Giberson's picture
18
Aug
2010
0 Votes 0
Login to vote

Thanks everyone...I got it

Thanks everyone...I got it working.

NBU 7.01 on Windows 2003 with LTO2 Library