I used Data Protector RMAN to backup an Oracle 11g db successfully.
However, I couldn't restore it to different machine and got the following error.
Any idea?
[Normal] From: RSM@hkdp9p01.localdomain "" Time: 6/1/2018 5:56:06 PM
Restore session 2018/06/01-22 started.
[Normal] From: ob2rman@sapistest01 "DEV" Time: 06/01/18 17:56:07
Starting restore of target database.
Net service name: DEV.
Instance status: MOUNTED.
Instance name: DEV.
Database DBID = 3633358293.
Database control file type: CURRENT.
Database log mode: ARCHIVELOG.
[Normal] From: ob2rman@sapistest01 "DEV" Time: 06/01/18 17:56:07
Starting Oracle Recovery Manager.
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Jun 1 17:56:07 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN> CONNECT TARGET *
2> HOST 'exit';
3> run {
4> allocate channel 'dev_0' type 'sbt_tape'
5> parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=DEV,OB2BARLIST=1527846966,OB2BARHOSTNAME=hksadbd1.sasa.com)';
6> restore database;
7> recover database;
8> sql 'alter database open';
9> release channel 'dev_0';
10> }
11> EXIT
RMAN-06568: connected to target database: DEV (DBID=3633358293, not open)
RMAN-06009: using target database control file instead of recovery catalog
RMAN-08030: allocated channel: dev_0
RMAN-08500: channel dev_0: SID=133 device type=SBT_TAPE
RMAN-08526: channel dev_0: Data Protector A.09.00/107
RMAN-03090: Starting restore at 01-JUN-18
RMAN-08016: channel dev_0: starting datafile backup set restore
RMAN-08089: channel dev_0: specifying datafile(s) to restore from backup set
RMAN-08610: channel dev_0: restoring datafile 00010 to /oracle/DEV/sapdata4/dev_8/dev.data8
RMAN-08610: channel dev_0: restoring datafile 00026 to /oracle/DEV/sapdata3/dev620_13/dev620.data13
RMAN-08610: channel dev_0: restoring datafile 00030 to /oracle/DEV/sapdata5/dev_14/dev.data14
RMAN-08610: channel dev_0: restoring datafile 00039 to /oracle/DEV/sapdata2/dimd_1/dimd.data1
RMAN-08610: channel dev_0: restoring datafile 00044 to /oracle/DEV/sapdata2/facti_1/facti.data1
RMAN-08003: channel dev_0: reading from backup piece SAP_DEV_DB_ArchiveLog<DEV_27632:975605752:1>.dbf
RMAN-08615: channel dev_0: ORA-19870: error while restoring backup piece SAP_DEV_DB_ArchiveLog<DEV_27632:975605752:1>.dbf
ORA-19507: failed to retrieve sequential file, handle="SAP_DEV_DB_ArchiveLog<DEV_27632:975605752:1>.dbf", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Vendor specific error: SBT_Query_for_objects(...) call failed
ERR(0)
... ... ... ...
... ... ... ...
RMAN-08016: channel dev_0: starting datafile backup set restore
RMAN-08089: channel dev_0: specifying datafile(s) to restore from backup set
RMAN-08610: channel dev_0: restoring datafile 00013 to /oracle/DEV/sapdata3/dev620_2/dev620.data2
RMAN-08610: channel dev_0: restoring datafile 00018 to /oracle/DEV/sapdata3/dev620_7/dev620.data7
RMAN-08610: channel dev_0: restoring datafile 00034 to /oracle/DEV/sapdata5/dev_18/dev.data18
RMAN-08610: channel dev_0: restoring datafile 00042 to /oracle/DEV/sapdata2/odsi_1/odsi.data1
RMAN-08610: channel dev_0: restoring datafile 00049 to /oracle/DEV/sapdata2/dev731_5/dev731.data5
RMAN-08003: channel dev_0: reading from backup piece SAP_DEV_DB_ArchiveLog<DEV_27626:975605752:1>.dbf
RMAN-08615: channel dev_0: ORA-19870: error while restoring backup piece SAP_DEV_DB_ArchiveLog<DEV_27626:975605752:1>.dbf
ORA-19507: failed to retrieve sequential file, handle="SAP_DEV_DB_ArchiveLog<DEV_27626:975605752:1>.dbf", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Vendor specific error: SBT_Query_for_objects(...) call failed
ERR(0)
RMAN-08016: channel dev_0: starting datafile backup set restore
RMAN-08089: channel dev_0: specifying datafile(s) to restore from backup set
RMAN-08610: channel dev_0: restoring datafile 00003 to /oracle/DEV/sapdata4/dev_1/dev.data1
RMAN-08610: channel dev_0: restoring datafile 00007 to /oracle/DEV/sapdata4/dev_5/dev.data5
RMAN-08610: channel dev_0: restoring datafile 00009 to /oracle/DEV/sapdata4/dev_7/dev.data7
RMAN-08610: channel dev_0: restoring datafile 00014 to /oracle/DEV/sapdata3/dev620_3/dev620.data3
RMAN-08610: channel dev_0: restoring datafile 00018 to /oracle/DEV/sapdata3/dev620_7/dev620.data7
RMAN-08610: channel dev_0: restoring datafile 00023 to /oracle/DEV/sapdata1/devusr_1/devusr.data1
RMAN-08610: channel dev_0: restoring datafile 00026 to /oracle/DEV/sapdata3/dev620_13/dev620.data13
RMAN-08610: channel dev_0: restoring datafile 00027 to /oracle/DEV/sapdata4/dev_11/dev.data11
RMAN-08610: channel dev_0: restoring datafile 00031 to /oracle/DEV/sapdata5/dev_15/dev.data15
RMAN-08610: channel dev_0: restoring datafile 00035 to /oracle/DEV/sapdata5/dev_19/dev.data19
RMAN-08610: channel dev_0: restoring datafile 00039 to /oracle/DEV/sapdata2/dimd_1/dimd.data1
RMAN-08610: channel dev_0: restoring datafile 00041 to /oracle/DEV/sapdata2/odsd_1/odsd.data1
RMAN-08610: channel dev_0: restoring datafile 00047 to /oracle/DEV/sapdata2/dev731_3/dev731.data3
RMAN-08003: channel dev_0: reading from backup piece DEV_DB_ARCHIVE_ECC6<DEV_27141:970878609:1>.dbf
RMAN-08615: channel dev_0: ORA-19870: error while restoring backup piece DEV_DB_ARCHIVE_ECC6<DEV_27141:970878609:1>.dbf
ORA-19507: failed to retrieve sequential file, handle="DEV_DB_ARCHIVE_ECC6<DEV_27141:970878609:1>.dbf", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Vendor specific error: SBT_Query_for_objects(...) call failed
ERR(0)
RMAN-05016: failover to previous backup
RMAN-06064: creating datafile file number=1 name=/oracle/DEV/sapdata1/system_1/system.data1
RMAN-08031: released channel: dev_0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/01/2018 18:02:03
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/oracle/DEV/sapdata1/system_1/system.data1'
Recovery Manager complete.
[Major] From: ob2rman@sapistest01 "DEV" Time: 06/01/18 18:02:04
External utility reported error.
RMAN PID=6250
[Major] From: ob2rman@sapistest01 "DEV" Time: 06/01/18 18:02:04
The database reported error while performing requested operation.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/01/2018 18:02:03
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/oracle/DEV/sapdata1/system_1/system.data1'
Recovery Manager complete.
[Major] From: ob2rman@sapistest01 "DEV" Time: 06/01/18 18:02:04
Oracle Recovery Manager completed with errors.
[Major] From: ob2rman@sapistest01 "DEV" Time: 06/01/18 18:02:04
Restore of target database failed.
[Normal] From: RSM@hkdp9p01.localdomain "" Time: 6/1/2018 6:02:07 PM
OB2BAR application on "sapistest01" disconnected.
[Normal] From: RSM@hkdp9p01.localdomain "" Time: 6/1/2018 6:02:07 PM
Restore Statistics:
Session Queuing Time (hours) 0.00
-------------------------------------------
Completed Disk Agents ........ 0
Failed Disk Agents ........... 0
Aborted Disk Agents .......... 0
-------------------------------------------
Disk Agents Total ........... 0
===========================================
Completed Media Agents ....... 0
Failed Media Agents .......... 0
Aborted Media Agents ......... 0
-------------------------------------------
Media Agents Total .......... 0
===========================================
Mbytes Total ................. 0 MB
Used Media Total ............. 0
Disk Agent Errors Total ...... 0
============================================================================
Session failed!
============================================================================