Oracle restore, 2 different netbackup domains with A.I.R

[Gergely_B_]

Hi, 

we have 2 different Netbackup domains PROD and UAT. Oracle backups are taken on PROD site then replicated over to UAT site with Netbackup AIR. 

DBA wants to restore PROD data on UAT site. 

(in netbackup policy we added script names in backup selection)

RMAN error: 
channel ch3: ORA-19870: error while restoring backup piece ***name*** 
ORA-19507: failed to retrieve sequential file, handle="***name*** ", parms="" 
ORA-27029: skgfrtrv: sbtrestore returned error 
ORA-19511: non RMAN, but media manager or vendor specific failure, error text: 
Failed to process backup file <***name*** >

in netbackup there is no sign of this restore job 

PROD side oracle server has PROD master and media server in bp.conf

UATside oracle server has UAT master and media server in bp.conf

RMAN restore script:

run {
allocate channel ch1 type 'SBT_TAPE';
allocate channel ch2 type 'SBT_TAPE';
allocate channel ch3 type 'SBT_TAPE';
allocate channel ch4 type 'SBT_TAPE';
allocate channel ch5 type 'SBT_TAPE';
allocate channel ch6 type 'SBT_TAPE';
allocate channel ch7 type 'SBT_TAPE';
allocate channel ch8 type 'SBT_TAPE';
send 'NB_ORA_SERV=UAT_MASTER, NB_ORA_CLIENT=UAT_CLIENT';
RESTORE DATABASE;
}

it seems UAT side oracle machine does not know about the backup pieces AIR-ed from PROD to UAT

any help is much appreciated

Gergo

[sdo · Accepted solution]

This should help:

How to restore backups to an alternate client using RMAN or EBU

https://support.symantec.com/en_US/article.TECH5840.html

[RiaanBadenhorst · Accepted solution]

RMAN doesnt know about the backup so you'll need to restore the restore the control file first (assuming you dont use an oracle recovery catalog)

https://support.symantec.com/en_US/article.HOWTO63971.html

Once that is done you can proceed with the restore as per SDO's note

[Marianne]

NB_ORA_CLIENT must be PROD client, not UAT. 

Above excellent TNs will help.

You can also read up about alternate client restore in NetBackup for Oracle Administrator's Guide