Home » RDBMS Server » Backup & Recovery » ORA-19554: error allocating device, device type: SBT_TAPE (Oracle 11g, Window 2008 R2 Server)
ORA-19554: error allocating device, device type: SBT_TAPE [message #615342] Mon, 02 June 2014 12:54 Go to next message
pandee
Messages: 2
Registered: June 2014
Location: Bangalore
Junior Member
I'm not a core DBA. The daily netbackup for a database is failing with the below error :

ERROR CODE [18:106]: RMAN Script execution failed with error [ORA-19554: error allocating device, device type: SBT_TAPE, device name: ]. Please check the Logs for more details.
Source: proddb01, Process: ClOraAgent


Can someone please help me figure out the issue? The RMAN script is given below. please let me know if any changes need to be made.

******DATA/CONTROL FILE/SPFILE BACKUP SCRIPT******
run {
allocate channel ch1 type 'sbt_tape'
PARMS="BLKSIZE=262144,SBT_UNSETENV=0,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1)"
TRACE 0;
allocate channel ch2 type 'sbt_tape'
PARMS="BLKSIZE=262144,SBT_UNSETENV=0,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch2)"
TRACE 0;
setlimit channel ch1 maxopenfiles 8;
setlimit channel ch2 maxopenfiles 8;
backup
incremental level = 1 
filesperset = 32 
format='f7686_<CVJOBID>_%d_%U'
database 
include current controlfile ;
}
exit;


******LOGS BACKUP SCRIPT******
run {
allocate channel ch1 type 'sbt_tape'
PARMS="BLKSIZE=262144,SBT_UNSETENV=0,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1)"
TRACE 0;
allocate channel ch2 type 'sbt_tape'
PARMS="BLKSIZE=262144,SBT_UNSETENV=0,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch2)"
TRACE 0;
setlimit channel ch1 maxopenfiles 8;
setlimit channel ch2 maxopenfiles 8;
sql "alter system archive log current";
backup 
filesperset = 32 
format='f7686_<CVJOBID>_%d_%U'
(archivelog all delete input );

backup format='f7686_<CVJOBID>_%d_%U'
current controlfile ; 
}
exit;




Re: ORA-19554: error allocating device, device type: SBT_TAPE [message #615344 is a reply to message #615342] Mon, 02 June 2014 12:57 Go to previous messageGo to next message
Michel Cadot
Messages: 59149
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ORA-19554: error allocating device, device type: %s, device name: %s
 *Cause:  The specified device could not be allocated.
 *Action: One or more other messages should be displayed to help pinpoint
          the cause of the error.  Correct the error and retry the
          allocation.
Re: ORA-19554: error allocating device, device type: SBT_TAPE [message #615345 is a reply to message #615344] Mon, 02 June 2014 13:05 Go to previous messageGo to next message
pandee
Messages: 2
Registered: June 2014
Location: Bangalore
Junior Member
Thanks Michel, for the quick response.

I've attached the RMAN log herewith, if it can provide any additional information...
  • Attachment: RMAN Logs.txt
    (Size: 105.44KB, Downloaded 42 times)
Re: ORA-19554: error allocating device, device type: SBT_TAPE [message #615347 is a reply to message #615345] Mon, 02 June 2014 13:13 Go to previous messageGo to next message
Michel Cadot
Messages: 59149
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes can you provide RMAN log file not OS trace file, it will contain the other messages associated to the one you posted.

Re: ORA-19554: error allocating device, device type: SBT_TAPE [message #615424 is a reply to message #615347] Tue, 03 June 2014 14:02 Go to previous message
babuknb
Messages: 1731
Registered: December 2005
Location: NJ
Senior Member


Can you try http://www.orafaq.com/forum/t/159158/

Previous Topic: after restore when trying to recover database.. it gives error
Next Topic: Rman backup gives error message RMAN-00554
Goto Forum:
  


Current Time: Sun Sep 21 15:53:22 CDT 2014

Total time taken to generate the page: 0.08102 seconds