Oracle restore, 2 different netbackup domains with A.I.R
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
This should help:
How to restore backups to an alternate client using RMAN or EBU
https://support.symantec.com/en_US/article.TECH5840.html
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