Can't Restore Oracle Backup with Backup Exec 2010

[Otakar]

I have successfully Backup Oracle 10.2.0.3 using Backup Exec 2010 agent and now I am not able to restore to new server due to problem with RMAN and BackupExec Integration - see scripts bellow. I very aprecieate if anyone have any idea or exprerience BACKUP - RMAN OUTPUT Recovery Manager: Release 10.2.0.3.0 - Production on Ne Dub 11 01:07:09 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. # ----------------------------------------------------------------- # RMAN command section # ----------------------------------------------------------------- RUN { ALLOCATE CHANNEL ch0 TYPE 'SBT_TAPE'; SEND 'BSA_SERVICE_HOST=192.168.1.17,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={18EC6370-2B6C-4907-B8AF-EA911E88C85C},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\CZRLPA-ORA1\arbes'; BACKUP INCREMENTAL LEVEL=0 FORMAT 'BE_U' DATABASE FORCE; BACKUP FORMAT 'BE_U' ARCHIVELOG ALL FORCE NOT BACKED UP DELETE INPUT; RELEASE CHANNEL ch0; } connected to target database: ARBES (DBID=1030808526) using target database control file instead of recovery catalog allocated channel: ch0 channel ch0: sid=284 devtype=SBT_TAPE channel ch0: Symantec/BackupExec/1.1.0 sent command to channel: ch0 Starting backup at 11.04.10 channel ch0: starting incremental level 0 datafile backupset channel ch0: specifying datafile(s) in backupset input datafile fno=00004 name=D:\ORACLE\ORADATA\ARBES\ARBESDATA.ORA input datafile fno=00005 name=E:\ORACLE\ORADATA\ARBES\ARBESIDX.ORA input datafile fno=00010 name=D:\ORACLE\ORADATA\ARBES\ARBESDATA2.ORA input datafile fno=00002 name=D:\ORACLE\ORADATA\ARBES\ARBESRBS.ORA input datafile fno=00007 name=E:\ORACLE\ORADATA\TKLEASING\TK_DATA1.DBF input datafile fno=00001 name=D:\ORACLE\ORADATA\ARBES\ARBESSYS.ORA input datafile fno=00006 name=D:\ORACLE\ORADATA\ARBES\ARBESDOC.ORA input datafile fno=00008 name=E:\ORACLE\ORADATA\TKLEASING\TK_DATA2.DBF input datafile fno=00009 name=E:\ORACLE\ORADATA\TKLEASING\TK_DATATEST.DBF input datafile fno=00003 name=D:\ORACLE\ORADATA\ARBES\ARBESAUX.ORA input datafile fno=00011 name=E:\ORACLE\ORADATA\TKLEASING\USR1.DBF channel ch0: starting piece 1 at 11.04.10 channel ch0: finished piece 1 at 11.04.10 piece handle=BE_sslaqjil_1_1 tag=TAG20100411T010733 comment=API Version 2.0,MMS Version 1.1.0.0 channel ch0: backup set complete, elapsed time: 00:50:36 Finished backup at 11.04.10 Starting backup at 11.04.10 current log archived channel ch0: starting archive log backupset channel ch0: specifying archive log(s) in backup set input archive log thread=1 sequence=2297298 recid=2297302 stamp=715933908 input archive log thread=1 sequence=2297299 recid=2297303 stamp=715934356 input archive log thread=1 sequence=2297300 recid=2297304 stamp=715934868 input archive log thread=1 sequence=2297301 recid=2297305 stamp=715935338 input archive log thread=1 sequence=2297302 recid=2297306 stamp=715935761 input archive log thread=1 sequence=2297303 recid=2297307 stamp=715936271 input archive log thread=1 sequence=2297304 recid=2297308 stamp=715936779 input archive log thread=1 sequence=2297305 recid=2297309 stamp=715939361 input archive log thread=1 sequence=2297306 recid=2297310 stamp=715943200 input archive log thread=1 sequence=2297307 recid=2297311 stamp=715947021 input archive log thread=1 sequence=2297308 recid=2297312 stamp=715950880 input archive log thread=1 sequence=2297309 recid=2297313 stamp=715954720 input archive log thread=1 sequence=2297310 recid=2297314 stamp=715958593 input archive log thread=1 sequence=2297311 recid=2297315 stamp=715962478 input archive log thread=1 sequence=2297312 recid=2297316 stamp=715966361 input archive log thread=1 sequence=2297313 recid=2297317 stamp=715970241 input archive log thread=1 sequence=2297314 recid=2297318 stamp=715974161 input archive log thread=1 sequence=2297315 recid=2297319 stamp=715978040 input archive log thread=1 sequence=2297316 recid=2297320 stamp=715981951 input archive log thread=1 sequence=2297317 recid=2297321 stamp=715985800 input archive log thread=1 sequence=2297318 recid=2297322 stamp=715989643 input archive log thread=1 sequence=2297319 recid=2297323 stamp=715993480 input archive log thread=1 sequence=2297320 recid=2297324 stamp=715994157 input archive log thread=1 sequence=2297321 recid=2297325 stamp=715994170 input archive log thread=1 sequence=2297322 recid=2297326 stamp=715996844 input archive log thread=1 sequence=2297323 recid=2297327 stamp=715999683 input archive log thread=1 sequence=2297324 recid=2297328 stamp=716003027 input archive log thread=1 sequence=2297325 recid=2297329 stamp=716003891 channel ch0: starting piece 1 at 11.04.10 channel ch0: finished piece 1 at 11.04.10 piece handle=BE_stlaqmhp_1_1 tag=TAG20100411T015816 comment=API Version 2.0,MMS Version 1.1.0.0 channel ch0: backup set complete, elapsed time: 00:00:26 channel ch0: deleting archive log(s) archive log filename=D:\BACKUPLOG\ARBES064482905400197298.ARC recid=2297302 stamp=715933908 archive log filename=D:\BACKUPLOG\ARBES064482905400197299.ARC recid=2297303 stamp=715934356 archive log filename=D:\BACKUPLOG\ARBES064482905400197300.ARC recid=2297304 stamp=715934868 archive log filename=D:\BACKUPLOG\ARBES064482905400197301.ARC recid=2297305 stamp=715935338 archive log filename=D:\BACKUPLOG\ARBES064482905400197302.ARC recid=2297306 stamp=715935761 archive log filename=D:\BACKUPLOG\ARBES064482905400197303.ARC recid=2297307 stamp=715936271 archive log filename=D:\BACKUPLOG\ARBES064482905400197304.ARC recid=2297308 stamp=715936779 archive log filename=D:\BACKUPLOG\ARBES064482905400197305.ARC recid=2297309 stamp=715939361 archive log filename=D:\BACKUPLOG\ARBES064482905400197306.ARC recid=2297310 stamp=715943200 archive log filename=D:\BACKUPLOG\ARBES064482905400197307.ARC recid=2297311 stamp=715947021 archive log filename=D:\BACKUPLOG\ARBES064482905400197308.ARC recid=2297312 stamp=715950880 archive log filename=D:\BACKUPLOG\ARBES064482905400197309.ARC recid=2297313 stamp=715954720 archive log filename=D:\BACKUPLOG\ARBES064482905400197310.ARC recid=2297314 stamp=715958593 archive log filename=D:\BACKUPLOG\ARBES064482905400197311.ARC recid=2297315 stamp=715962478 archive log filename=D:\BACKUPLOG\ARBES064482905400197312.ARC recid=2297316 stamp=715966361 archive log filename=D:\BACKUPLOG\ARBES064482905400197313.ARC recid=2297317 stamp=715970241 archive log filename=D:\BACKUPLOG\ARBES064482905400197314.ARC recid=2297318 stamp=715974161 archive log filename=D:\BACKUPLOG\ARBES064482905400197315.ARC recid=2297319 stamp=715978040 archive log filename=D:\BACKUPLOG\ARBES064482905400197316.ARC recid=2297320 stamp=715981951 archive log filename=D:\BACKUPLOG\ARBES064482905400197317.ARC recid=2297321 stamp=715985800 archive log filename=D:\BACKUPLOG\ARBES064482905400197318.ARC recid=2297322 stamp=715989643 archive log filename=D:\BACKUPLOG\ARBES064482905400197319.ARC recid=2297323 stamp=715993480 archive log filename=D:\BACKUPLOG\ARBES064482905400197320.ARC recid=2297324 stamp=715994157 archive log filename=D:\BACKUPLOG\ARBES064482905400197321.ARC recid=2297325 stamp=715994170 archive log filename=D:\BACKUPLOG\ARBES064482905400197322.ARC recid=2297326 stamp=715996844 archive log filename=D:\BACKUPLOG\ARBES064482905400197323.ARC recid=2297327 stamp=715999683 archive log filename=D:\BACKUPLOG\ARBES064482905400197324.ARC recid=2297328 stamp=716003027 archive log filename=D:\BACKUPLOG\ARBES064482905400197325.ARC recid=2297329 stamp=716003891 Finished backup at 11.04.10 Starting Control File Autobackup at 11.04.10 piece handle=c-1030808526-20100411-00 comment=API Version 2.0,MMS Version 1.1.0.0 Finished Control File Autobackup at 11.04.10 released channel: ch0 Recovery Manager complete. Devices acquired: 1 Data streams used: 1 RESTORE - RMAN OUTPUT = PROBLEM Copyright (c) 1982, 2007, Oracle. All rights reserved. # ----------------------------------------------------------------- # RMAN command section # ----------------------------------------------------------------- RUN { ALLOCATE CHANNEL ch0 TYPE 'SBT_TAPE'; SEND 'BSA_SERVICE_HOST=192.168.1.17,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={49E6C9CD-4546-4384-AB00-AB5B9A763AE2},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\CZRLPA-ORA2\ARBES,NBBSA_SOURCE_MACHINE_NAME=CZRLPA-ORA1'; RESTORE CONTROLFILE FROM 'c-1030808526-20100411-00'; ALTER DATABASE MOUNT; RESTORE DATABASE; RECOVER DATABASE; RELEASE CHANNEL ch0; alter database open resetlogs; } connected to target database: ARBES (not mounted) using target database control file instead of recovery catalog allocated channel: ch0 channel ch0: sid=154 devtype=SBT_TAPE channel ch0: Symantec/BackupExec/1.1.0 sent command to channel: ch0 Starting restore at 28-APR-10 released channel: ch0 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 04/28/2010 09:01:59 ORA-27191: sbtinfo2 returned error Recovery Manager complete.

[RahulG]

Rerun the full backup Job again and then try the restore

[Otakar]

Resolution is to add Media Server to Oracle Server List in Media Server -> Tools -> Option - Oracle tab.  I have just tried it -> According documentation only Oracle server should be in list. 

I have contacted Symantec Enterprise Support to open the case because valid contract but nobody answered me even I' ve escalate it - no reaction. I am quite disapointed.