rman fails to allocate device

bshapiro

ADSM.ORG Member
Joined
Mar 17, 2006
Messages
7
Reaction score
0
Points
0
Website
Visit site
PREDATAR Control23

We have been running TDP for oracle for some time. We recently had to change node passwords and following this we cannot sucessfully run our rman backup. The messages below are a slightly expanded form of what we are seeing as I turned debugging on and then off in the rman script. A complete copy of the log is available if someone felt it would be a help.



Can anyone point me in a possible direction?



<messages follow>

rman_command.060317.log



RMAN-00571: ==================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS==============

RMAN-00571: ==================================================

RMAN-03009: failure of allocate command on d1 channel at 03/17/2006 11:25:04

RMAN-10032: unhandled exception during execution of job step 1:

ORA-19624: operation failed, retry possible

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

ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer

IBM AIX RISC System/6000 Error: 106: Reserved errno was encountered

Additional information: 7011

ORA-19511: Error received from media manager layer, error text:

SBT error = 7011, errno = 106, sbtopen: system error

ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 137

ORA-06512: at line 27

RMAN-10035: exception raised in RPC:

ORA-19624: operation failed, retry possible

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

ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer

IBM AIX RISC System/6000 Error: 106: Reserved errno was encountered

Additional information: 7011

ORA-19511: Error received from media manager layer, error text:

SBT error = 7011, errno = 106, sbtopen: system error

ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 137

RMAN-10031: RPC Error: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.DEVICEALLOCATE



Recovery Manager complete.

DBGRPC: krmxcd: xc=4573124888

DBGRPC: krmxcd: xc=4573135312



<end of messages>



fyi - our 3494 library contains a pool of 4 3590-e1a drives and two of these are available for the rman backup to use.



Brian Shapiro
 
PREDATAR Control23

Error no 106 is file open error. Usually the log files causing this problem, but in this case it could be the password file as well chek it that the oracle suer can access this files.
 
PREDATAR Control23

tdp oracle similar issue

hi friends,
im getting similar issue

using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on t1 channel at 07/18/2008 13:51:10
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
IBM AIX RISC System/6000 Error: 106: For future use
Additional information: 7011
ORA-19511: Error received from media manager layer, error text:
SBT error = 7011, errno = 106, sbtopen: system error

script:
run
{
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)';
sql "alter system archive log current";
backup full
filesperset 20
format '%d_DB_FULL_%t_%s_%p'
tag 'loga_FULL_online'
(database);
release channel t1;
}
tdpoconf showenv


IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 4, Level 1.0
(C) Copyright IBM Corporation 1997, 2007. All rights reserved.

Data Protection for Oracle Information
Version: 5
Release: 4
Level: 1
Sublevel: 0
Platform: 64bit TDP Oracle AIX
Tivoli Storage Manager Server Information
Server Name: BACKUPSERVER_SERVER1
Server Address: 172.17.12.38
Server Type: Windows
Server Port: 1500
Communication Method: TCP/IP
Session Information
Owner Name:
Node Name: spitdbatm0001
Node Type: TDP Oracle AIX
DSMI_DIR: /usr/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG: /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
TDPO_OPTFILE: /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
Password Directory: /usr/tivoli/tsm/client/oracle/bin64
Compression: FALSE
License Information: License file exists and contains valid license data.
..
any mistakes in this
 
PREDATAR Control23

thanks nezih, its working fine nw..
its purely permision issue... solved..
thanks again
 
PREDATAR Control23

give write permission to dsi or dsmerror.log and try again

Have you ever seen tdpoerror.log get set to readonly when using tdpoconf? Anytime I use it for anything, when setting up a new Oracle TDP client on a currently used server, to set the password, or if I use it with showenv, my tdpoerror.log file always goes to read-only. And if I forget that this does this and forget to reset it to read-write, my backups fail and I only remember it when I get the failure. It's very annoying. Do you know why this happens?
 
PREDATAR Control23

it's always comes with readonly and chmod became the latest step of tdpo installation greg... I don't know why but always I give write permissions to it
 
Top