RMAN Script execution failed with error [ORA-19554: error allocating device, device type: SBT_TAPE, device name:

Last post 11-05-2018, 5:29 AM by macmecki. 0 replies.
Sort Posts: Previous Next
  • RMAN Script execution failed with error [ORA-19554: error allocating device, device type: SBT_TAPE, device name:
    Posted: 11-05-2018, 5:29 AM

    Hello,

    since 1 week we had problems with the backup of the oracle DB. We ever get the message

    RMAN Script execution failed with error [ORA-19554: error allocating device, device type: SBT_TAPE, device name:

     

    The oracle DB runs on a Windows Server 2012 R2 and Commvault was V11 SP13+Hotfixes

    What can i do to solve this problem?

     

    regards

    chris

     

    15112 b9c   11/05 09:01:59 1484884 OraChildProcess::Finalize() - start
    15112 b9c 11/05 09:01:59 1484884 OraObject::GetOraMode() - oraMode = READ WRITE.
    15112 b9c 11/05 09:01:59 1484884 OraChildProcess::Initialize() - enter
    15112 b9c 11/05 09:01:59 1484884 OraChildProcess::ReadBuf() - ReadFile: LastError=109
    15112 b9c 11/05 09:01:59 1484884 OraChildProcess::Wait() - Child OK
    15112 b9c 11/05 09:01:59 1484884 OraChildProcess::Finalize() - start
    15112 b9c 11/05 09:01:59 1484884 OracleBrowser::ProcessBrowseResultAndUpdate() - Installed Instance :Instance001
    15112 b9c 11/05 09:01:59 1484884 OraBaseBrowser::UpdateRepository() - ArchLogMode = TRUE
    15112 b9c 11/05 09:01:59 1484884 OraBaseBrowser::UpdateRepository() - instanceTempFileCount=[1]
    15112 b9c 11/05 09:01:59 1484884 OraBaseBrowser::UpdateRepository() - newTempFileCount=1
    15112 b9c 11/05 09:01:59 1484884 OraBaseBrowser::UpdateRepository() - ArchLogMode = TRUE
    15112 b9c 11/05 09:01:59 1484884 OraBaseBrowser::UpdateRepository() - dataSize=[3585671168] maxSize=[26992967680]
    15112 b9c 11/05 09:01:59 1484884 OraBaseBrowser::UpdateRepository() - calling upateOracleProperties on IdaBackup with 5 tblspaces
    15112 b9c 11/05 09:01:59 1484884 OraBaseBrowser::UpdateRepository() - update Oracle Properties done.
    15112 b9c 11/05 09:01:59 1484884 OraBaseBrowser::UpdateRepository() - version = 12.1.0.2.0
    15112 b9c 11/05 09:01:59 1484884 ::CreateRmanLogFileChosen() - enter
    15112 b9c 11/05 09:01:59 1484884 JOBRESCACHEDIR: job 1484884 creating 'C:\Program Files\CommVault\Simpana\iDataAgent\JobResults\CV_JobResults\2\0\1484884'
    15112 b9c 11/05 09:01:59 1484884 OraBaseScriptGen::BackupPieceFormat(4618) - Default backup piece format:[1484884_%d_%U]
    15112 b9c 11/05 09:01:59 1484884 ::GenBackupScript() - DISKRATIO=-1
    15112 b9c 11/05 09:01:59 1484884 OraAgentBase20::BrowseInit(4873) - Initialize0(oraUser[] oraHome=[o:\app\oracle\product\12.1.0\dbhome_1\] oraSID=[GBIS])
    15112 b9c 11/05 09:01:59 1484884 ::GetNlsLang() - fetching registry key NLS_LANG
    15112 b9c 11/05 09:01:59 1484884 ::GetNlsLang() - registry key NLS_LANG not set therefore setting NLS_LANG to American_America.US7ASCII
    15112 b9c 11/05 09:01:59 1484884 OraObject::GetOraMode() - strictSID = 0
    15112 b9c 11/05 09:01:59 1484884 OraChildProcess::Initialize() - enter
    15112 b9c 11/05 09:01:59 1484884 OraChildProcess::ReadBuf() - ReadFile: LastError=109
    15112 b9c 11/05 09:01:59 1484884 OraChildProcess::Wait() - Child OK
    15112 b9c 11/05 09:01:59 1484884 OraChildProcess::Finalize() - start
    15112 b9c 11/05 09:01:59 1484884 OraObject::GetOraMode() - oraMode = READ WRITE.
    15112 b9c 11/05 09:01:59 1484884 OraChildProcess::Initialize() - enter
    15112 b9c 11/05 09:01:59 1484884 OraChildProcess::ReadBuf() - ReadFile: LastError=109
    15112 b9c 11/05 09:01:59 1484884 OraChildProcess::Wait() - Child OK
    15112 b9c 11/05 09:01:59 1484884 OraChildProcess::Finalize() - start
    15112 b9c 11/05 09:01:59 1484884 OraBaseBrowser::GetParameter(1603)() - errMsg=[Parameter [backup optimization] not set..]
    15112 b9c 11/05 09:01:59 1484884 OraBaseBrowser::GetParameter(1603)() - IsSetJPR = [FALSE]
    15112 b9c 11/05 09:01:59 1484884 OraBaseBrowser::GetParameter(1603)() - IsAlreadySent = [FALSE]
    15112 b9c 11/05 09:01:59 1484884 OraBaseBrowser::GetParameter(1603)() - Error with Stack[0xECCC065B:{OraBaseBrowser::GetParameter(1603)/ErrNo.1627.(Unknown error)-Parameter [backup optimization] not set..}]
    15112 b9c 11/05 09:01:59 1484884 OraBaseScriptGen::AddDisableRMANOptimization(950) - Error querying v$rman_configuration view:Parameter [backup optimization] not set..
    15112 b9c 11/05 09:01:59 1484884 OraBaseScriptGen::GenMergeIncrementalScript() - m_isMergeIncremental=[0] m_appType [22]
    15112 b9c 11/05 09:01:59 1484884 OraBaseScript::GetBkpStreamsToUse() - Data backup FULL/Partial
    15112 b9c 11/05 09:01:59 1484884 OraBaseScript::GetBkpStreamsToUse() - streams to use = 1
    15112 b9c 11/05 09:01:59 1484884 ::GenBackupScript() - ARCHIVE_LOG_CRITERIA typeId=7
    15112 b9c 11/05 09:01:59 1484884 OraBaseScript::GetBkpStreamsToUse() - Data backup FULL/Partial
    15112 b9c 11/05 09:01:59 1484884 OraBaseScript::GetBkpStreamsToUse() - streams to use = 1
    15112 b9c 11/05 09:01:59 1484884 OraBaseScriptGen::RmanSendOption() - Oracle version=[12.1.0.2.0]
    15112 b9c 11/05 09:01:59 1484884 OraBaseScriptGen::RmanSendOption() - 2 Using RMAN send command
    15112 b9c 11/05 09:01:59 1484884 OraBaseScriptGen::RmanSendOption() - Oracle version=[12.1.0.2.0]
    15112 b9c 11/05 09:01:59 1484884 OraBaseScriptGen::RmanSendOption() - 2 Using RMAN send command
    15112 b9c 11/05 09:01:59 1484884 OraBaseScriptGen::AddBkpSizesLimitsScript() - maxOpenFiles=Music [8]
    15112 b9c 11/05 09:01:59 1484884 OraBaseScriptGen::AddBkpSizesLimitsScript() - maxBackupSetSize = [0]
    15112 b9c 11/05 09:01:59 1484884 OraBaseScriptGen::AddBkpSizesLimitsScript() - Data fileperset:[0]
    15112 b9c 11/05 09:01:59 1484884 OraBaseScriptGen::AddRmanOptFix(1784) - sRMANOPTPERFFIX = 1
    15112 b9c 11/05 09:01:59 1484884 OraBaseScriptGen::AddMaxCorruptLine() - Backup Mode 0, MAXBLOCKCORRUPTS=0
    15112 b9c 11/05 09:02:00 1484884 ::GenBackupScript() - maxBackupSetSize=0
    15112 b9c 11/05 09:02:00 1484884 OraBaseScriptGen::ParseRmanTagFormat() - user specified tag :
    15112 b9c 11/05 09:02:00 1484884 ::GenBackupScript() - backupLevel = 0
    15112 b9c 11/05 09:02:00 1484884 ClOraAgent::GenerateRmanScript() - Script = [CONFIGURE CONTROLFILE AUTOBACKUP ON;
    run {
    allocate channel ch1 type 'sbt_tape'
    PARMS=" BLKSIZE=1048576 SBT_UNSETENV=0,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1,ThreadCommandLine= -cn ntgbis1 -vm Instance001)"
    TRACE 0;
    send "BACKUP -jm 32813 -a 2:1767 -cl 608 -ins 328 -at 22 -j 1484884 -jt 1484884:4:1 -bal 0 -t 1 -ms 1 -data";
    setlimit channel ch1 maxopenfiles 8;
    backup
    incremental level = 0
    filesperset = 32
    format='1484884_%d_%U'
    database
    include current controlfile ;
    }
    exit;
    ]
    15112 b9c 11/05 09:02:00 1484884 ClOraAgent::PostRecvRmanScript() - rman script: CONFIGURE CONTROLFILE AUTOBACKUP ON;
    run {
    allocate channel ch1 type 'sbt_tape'
    PARMS=" BLKSIZE=1048576 SBT_UNSETENV=0,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1,ThreadCommandLine= -cn ntgbis1 -vm Instance001)"
    TRACE 0;
    send "BACKUP -jm 32813 -a 2:1767 -cl 608 -ins 328 -at 22 -j 1484884 -jt 1484884:4:1 -bal 0 -t 1 -ms 1 -data";
    setlimit channel ch1 maxopenfiles 8;
    backup
    incremental level = 0
    filesperset = 32
    format='1484884_%d_%U'
    database
    include current controlfile ;
    }
    exit;
    15112 b9c 11/05 09:02:00 1484884 ExecuteAction() - Total rman block to execute : 1
    15112 b9c 11/05 09:02:00 1484884 ExecuteAction() - jobToken [1484884:4:1] Previous Phase Num [0] Rman Block Num [0].
    15112 b9c 11/05 09:02:00 1484884 ExecuteAction() - Executing rman block no :1 from rman script.
    15112 b9c 11/05 09:02:00 1484884 ::RunRman() - enter
    15112 b9c 11/05 09:02:00 1484884 ::VerifyOraVersion() - Loading DLL = C:\Program Files\CommVault\Simpana\Base\ORASBT.dll
    15112 b9c 11/05 09:02:00 1484884 ::VerifyOraVersion() - Running Version = 11.0.0(BUILD80)
    Install Version = 11.0.0(BUILD80)
    15112 b9c 11/05 09:02:00 1484884 ClOraAgent::GetInfoFromDB() - Trying Browse with B X
    15112 b9c 11/05 09:02:00 1484884 OraAgentBase20::BrowseInit(4873) - Initialize0(oraUser[] oraHome=[o:\app\oracle\product\12.1.0\dbhome_1\] oraSID=[GBIS])
    15112 b9c 11/05 09:02:00 1484884 ::GetNlsLang() - fetching registry key NLS_LANG
    15112 b9c 11/05 09:02:00 1484884 ::GetNlsLang() - registry key NLS_LANG not set therefore setting NLS_LANG to American_America.US7ASCII
    15112 b9c 11/05 09:02:00 1484884 ClOraAgent::GetInfoFromDB() - GetInfo(oraObjNameList=[B X])
    15112 b9c 11/05 09:02:00 1484884 OraObject::GetOraMode() - strictSID = 0
    15112 b9c 11/05 09:02:00 1484884 OraChildProcess::Initialize() - enter
    15112 b9c 11/05 09:02:00 1484884 OraChildProcess::ReadBuf() - ReadFile: LastError=109
    15112 b9c 11/05 09:02:00 1484884 OraChildProcess::Wait() - Child OK
    15112 b9c 11/05 09:02:00 1484884 OraChildProcess::Finalize() - start
    15112 b9c 11/05 09:02:00 1484884 OraObject::GetOraMode() - oraMode = READ WRITE.
    15112 b9c 11/05 09:02:00 1484884 OraChildProcess::Initialize() - enter
    15112 b9c 11/05 09:02:00 1484884 OraChildProcess::ReadBuf() - ReadFile: LastError=109
    15112 b9c 11/05 09:02:00 1484884 OraChildProcess::Wait() - Child OK
    15112 b9c 11/05 09:02:00 1484884 OraChildProcess::Finalize() - start
    15112 b9c 11/05 09:02:00 1484884 ::ReadjustStreamsForSBTCopyParam() - oraReturn =
    15112 b9c 11/05 09:02:00 1484884 ::RunRman() - nocatalog for RMAN
    15112 b9c 11/05 09:02:00 1484884 ::GetNlsLang() - fetching registry key NLS_LANG
    15112 b9c 11/05 09:02:00 1484884 ::GetNlsLang() - registry key NLS_LANG not set therefore setting NLS_LANG to American_America.US7ASCII
    15112 b9c 11/05 09:02:00 1484884 OraChildProcess::Initialize() - enter
    15112 b9c 11/05 09:02:00 1484884 OraChildProcess::BeginWait() - Rman thread with HNDL=2a8 TID=4168 EC=259 was created
    15112 1048 11/05 09:02:00 1484884 OraChildProcess::WaitThread() - start: thread Id=4168
    15112 1048 11/05 09:02:01 1484884 OraChildProcess::Wait() - Child process: dwExitCode=1
    15112 1048 11/05 09:02:01 1484884 OraChildProcess::WaitThread() - Wait failed; lastErr=1
    15112 b9c 11/05 09:02:03 1484884 OraChildProcess::ReadBuf() - Rman thread with HNDL=2b0 TID=16268 EC=259 was created
    15112 3f8c 11/05 09:02:03 1484884 OraChildProcess::ReadThread() - start: thread Id=16268
    15112 3f8c 11/05 09:02:03 1484884 OraChildProcess::ReadThread() - GETLASTERROR returned=109 (ret=0)
    15112 b9c 11/05 09:02:03 1484884 ::CloseJobResultsFile() - [1484884] going to m_buResults.closeFile...
    15112 b9c 11/05 09:02:03 1484884 JOBRESULTSTABLE(C:\Program Files\CommVault\Simpana\iDataAgent\JobResults\CV_JobResults\2\0\1484884\J removing copy 'C:\Program Files\CommVault\Simpana\iDataAgent\JobResults\CV_JobResults\2\0\1484884'
    15112 b9c 11/05 09:02:03 1484884 ::CloseJobResultsFile() - [1484884] m_buResults.closeFile() & cleanUp() succeeded.
    15112 b9c 11/05 09:02:03 1484884 OraChildProcess::Finalize() - start
    15112 b9c 11/05 09:02:03 1484884 ::ProcessComplete() - Sending ORA_MSG_RMAN_COMPLETE
    15112 b9c 11/05 09:02:03 1484884 ::RunRman() - m_rmanProcess->Failed().
The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Close
Copyright © 2019 Commvault | All Rights Reserved. | Legal | Privacy Policy