RMAN Restore failing in NBU 6.5.5
Updated: 19 Sep 2010 | 11 comments
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?
Discussion Filed Under:
Comments
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
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
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
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
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
Oracle RAC?
See this docuument:
http://support.veritas.com/docs/278508
good Will backing-up
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.
NBU 7.01 on Windows 2003 with LTO2 Library
client restore requests disallowed
See this document: http://seer.entsupport.symantec.com/docs/289477.htm
good Will backing-up
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...
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
Thanks everyone...I got it
Thanks everyone...I got it working.
NBU 7.01 on Windows 2003 with LTO2 Library
Would you like to reply?
Login or Register to post your comment.