Forum Discussion

Gergely_B_'s avatar
Gergely_B_
Level 3
10 years ago

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

  • 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

  • This should help:

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

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