cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Restore to Another Machine

abiand
Level 1

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

4 REPLIES 4

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@abiand 

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? 

Since you are specifying a server name as well as a client name just a slight modification to the bplist command shared by @Marianne

Please run the bplist command as below from the destination client where you are initiating the restore from


bplist -S bhpnbsrv -C psftdbsrv -t 4 -l -R /ctrl_dHRPROD_uq8ts0gds_s21320_p1_t1002455484

John_Whitehead_
Level 3

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.

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Seems @abiand registered here a week ago, posted above question, and never came back to look for answers....  Smiley Sad