09-21-2016 12:16 PM
My Envrionement consist of Main and DR Site
Main Site
DR Site
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 - ";
11-10-2016 01:23 PM
Try using the -EFI option on bplist. You'll get both the file with and with the ending timestamp.
11-10-2016 11:46 PM
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?