03-11-2019 03:10 AM - edited 03-11-2019 03:13 AM
Hi,
I'm try to Restore Controlfile using RMAN , and give the error below :
RMAN> run { 2> set controlfile autobackup format for device type 'sbt_tape' to '%F'; 3> allocate channel ch00 device type 'sbt_tape'; 4> send 'NB_ORA_SERV=bhpnbsrv, NB_ORA_CLIENT=psftdbsrv'; 5> restore controlfile from '/ctrl_dHRPROD_uq8ts0gds_s21320_p1_t1002455484 6> } executing command: SET CONTROLFILE AUTOBACKUP FORMAT allocated channel: ch00 channel ch00: SID=63 device type=SBT_TAPE channel ch00: Veritas NetBackup for Oracle - Release 7.6 (20131113) sent command to channel: ch00 Starting restore at 11-MAR-19 released channel: ch00 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 03/11/2019 17:03:40 ORA-27191: sbtinfo2 returned error
Please any sugestion would be very helpful.
Thanks,
Adam
03-12-2019 01:00 AM
We need more info, please.
Have you configured altnames on NBU master?
Can you use bplist command on the destination host to list backups for source client?
/usr/netbackup/bin/bplist -C <source-client> -t 4 -l -R /
The oracle user running bplist command and/or rman restore must have same user id number or same group id as on source client.
It seems as if you are missing a trailing ' after control file name:
'/ctrl_dHRPROD_uq8ts0gds_s21320_p1_t1002455484
Have you tried with '/ctrl_dHRPROD_uq8ts0gds_s21320_p1_t1002455484' ?
TN with steps to restore control file:
https://www.veritas.com/support/en_US/article.100037984.html
PS:
Are you aware that NBU 7.6.x ran out of support a couple of years ago?
03-13-2019 05:47 AM
03-19-2019 02:39 AM
Have you configured your alt names for re-directed restores?
/usr/openv/netbackup/db/altnames/client_name
Where client_name is the name of the client that is allowed to perform the redirected restore (the destination client). To the file, add the name of the NetBackup for Oracle source client.
You can put the no.restrictions file in there to allow anything to restore to anywhere but I strongly advise against it.
03-19-2019 03:03 AM
Seems @abiand registered here a week ago, posted above question, and never came back to look for answers....