ORA-19554: error allocating device, device type: SBT_TAPE, device name:

Received below error while restoring COLD backup of source database using RMAN at target server.



RMAN> run{
2> restore database;
3> }

Starting restore at 07-SEP-16
RMAN-06908: WARNING: operation will not run in parallel on the allocated channels
RMAN-06909: WARNING: parallelism require Enterprise Edition
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=391 device type=DISK
released channel: ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/07/2016 23:17:38
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 2



Cause : The reason of this failure is that on source database server has SBT_TAPE device type configured in RMAN( and we are using control file of source DB hence all SBT_TAPE decive configuration exists at target DB)  while on target server there was no Tape Drive attached to it.


RMAN> show all;

RMAN configuration parameters for database with db_unique_name ERPLN are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';

Solution : On target server, just clear the device type from SBT_TAPE to default device type which is disk using below command or you can explicitly allocate channels of device type inside RUN{} RMAN block to override its permanent configuration. In this case, I have cleared SBT_TAPE device type setting to default.

RMAN> CONFIGURE DEFAULT DEVICE TYPE CLEAR;

old RMAN configuration parameters:

CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';

RMAN configuration parameters are successfully reset to default value

Now try restoring the database again.

RMAN> run{

2> restore database;

3> }

Starting restore at 07-SEP-16

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=391 device type=DISK

channel ORA_DISK_1: restoring datafile 00001

input datafile copy RECID=244 STAMP=921971779 file name=/orabackup/PROD/ORADB/system01.dbf

destination for restore of datafile 00001: /oracle/oradata/PROD/system01.dbf

channel ORA_DISK_1: copied datafile copy of datafile 00001

output file name=/oracle/oradata/PROD/system01.dbf RECID=0 STAMP=0

channel ORA_DISK_1: restoring datafile 00002

input datafile copy RECID=246 STAMP=921971780 file name=/orabackup/PROD/ORADB/undotbs01.dbf

destination for restore of datafile 00002: /oracle/oradata/PROD/undotbs01.dbf

channel ORA_DISK_1: copied datafile copy of datafile 00002

output file name=/oracle/oradata/PROD/undotbs01.dbf RECID=0 STAMP=0

channel ORA_DISK_1: restoring datafile 00003

input datafile copy RECID=243 STAMP=921971779 file name=/orabackup/PROD/ORADB/sysaux01.dbf

destination for restore of datafile 00003: /oracle/oradata/PROD/sysaux01.dbf

channel ORA_DISK_1: copied datafile copy of datafile 00003

output file name=/oracle/oradata/PROD/sysaux01.dbf RECID=0 STAMP=0

channel ORA_DISK_1: restoring datafile 00004

input datafile copy RECID=247 STAMP=921971780 file name=/orabackup/PROD/ORADB/users01.dbf

destination for restore of datafile 00004: /oracle/oradata/PROD/users01.dbf

channel ORA_DISK_1: copied datafile copy of datafile 00004

output file name=/oracle/oradata/PROD/users01.dbf RECID=0 STAMP=0

channel ORA_DISK_1: restoring datafile 00005

input datafile copy RECID=237 STAMP=921971779 file name=/orabackup/PROD/ORADB/erplntoolsdat01.dbf

destination for restore of datafile 00005: /oracle/oradata/PROD/erplntoolsdat01.dbf

Hope it would help someone ....!!