cancel
Showing results for 
Search instead for 
Did you mean: 

RMAN Restore failing in NBU 6.5.5

Dan_Giberson
Level 5
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?
1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified


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




View solution in original post

11 REPLIES 11

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
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.

Dan_Giberson
Level 5
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.

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
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...

Oddy
Level 5
Employee

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


Will_Restore
Level 6

Dan_Giberson
Level 5
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.

Dan_Giberson
Level 5
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.

Will_Restore
Level 6

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified


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




View solution in original post

Manoj_Siricilla
Level 4
Certified
Paste the output of the following

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


Dan_Giberson
Level 5
Thanks everyone...I got it working.