Netbackup Copilot for Oracle - redirect restore from Auto Image Replication

[amr-tarek]

My Envrionement consist of Main and DR Site

Main Site

1. Master Server version 7.7.3 ( Windows Server 2008R2 )
2. NetBackup Media Server Appliance 2.7.3 
3. Oracle Server

DR Site 

1. Master Server version 7.7.3 ( Windows Server 2008R2 )
2. NetBackup Media Server Appliance 2.7.3 

We Successfully Configured Oracle Copilot and the backup windows enhanced dramatically , but we have an issue regarding restore the entire database including (Control Files & Data Files) on a Cloned Oracle System that we are not able to restore the control files from the DR Site while it exists in the bplist output but with format "/mnt/cf_D-OracleSID_I-DBID_T-20160920_2krga4a8_P_NBClient_ora"  where fails while trying to restore from this backup image and gives the following error;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/20/2016 19:26:20
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

Unless we add a TimeStamp which is not shown or listed except in the detailed status of the backup job in the main site with following format "/mnt/cf_D-OracleSID_I-DBID_T-20160920_2krga4a8_P_NBClient_ora_1474390195"

This is the detailed output which showing the timestamp

09/20/2016 19:33:40 - Info bphdb (pid=24461) INF - BEGIN
09/20/2016 19:33:40 - Info bphdb (pid=24461) INF - dev:=sys.dbms_backup_restore.deviceAllocate(type=>''SBT_TAPE'',ident=>''cat'',params=>''SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64,ENV=(NB_ORA_CLIENT=EGERPDB01.adib.co.ae,NB_ORA_SERV=,NB_ORA_JOB_SUBTYPE=7,NB_ORA_SID=,NB_ORA_PARENT_JOBID=369703)'');
09/20/2016 19:33:40 - Info bphdb (pid=24461) INF - sys.dbms_backup_restore.inspectBackupPiece (''/mnt/cf_D-OracleSID_I-1505037237_T-20160920_2krga4a8_P_NBClient_ora_1474390195'',fname,recid,stamp);
09/20/2016 19:33:40 - Info bphdb (pid=24461) INF - sys.dbms_backup_restore.deviceDeallocate;
09/20/2016 19:33:40 - Info bphdb (pid=24461) INF - END;
09/20/2016 19:33:40 - Info bphdb (pid=24461) INF - ";

[Reks]

Try using the -EFI option on bplist.  You'll get both the file with and with the ending timestamp.

[Marianne2]

This discussion is already more than a month old - probably because there is very little hands-on experience with Oracle Copilot. 

My concern is with the fact that Oracle at the production site seems to only know about the disk backup to /mnt.

Tell us more about you Oracle Copilot config - has the NBU portion to 'sweep' the disk backup into NBU been configured? 
With AIR replication to remote site? 

What does 
RMAN> list copy of database; 
on Prod and DR show?