Oracle restore

[tsmdumber]

Hi Guys

While allocatin channel for restore I get this error. And I am really screwed bif time.


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on t1 channel at 02/16/2011 10:27:29
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
Linux Error: 106: Transport endpoint is already connected
Additional information: 7011
ORA-19511: Error received from media manager layer, error text:
SBT error = 7011, errno = 106, sbtopen: system error



Show env as below

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

Data Protection for Oracle Information
Version: 5
Release: 5
Level: 2
Sublevel: 0
Platform: 32bit TDPO Linux86
Tivoli Storage Manager Server Information
Server Name: TSM_ORA
Server Address: 10.1.20.52
Server Type: AIX-RS/6000
Server Port: 1700
Communication Method: TCP/IP
Session Information
Owner Name:
Node Name: LI0BASDB01P_ora
Node Type: TDPO Linux86
DSMI_DIR: /opt/tivoli/tsm/client/api/bin
DSMI_ORC_CONFIG: /opt/tivoli/tsm/client/api/bin/dsm.opt
TDPO_OPTFILE: /opt/tivoli/tsm/client/oracle/bin/tdpo.opt
Password Directory: /opt/tivoli/tsm/client/oracle/bin
Compression: FALSE
License Information: License file exists and contains valid license data.

 

[Harry_Redl]

Hi,

7011,rc=106 - it is (almost) always permission issue with the error log.
Issue "chown -R oracle /opt/tivoli/tsm/client/*"
(replace "oracle" with you real oracle user)

Harry

 

[tsmdumber]

No luck!! Chmod 777 to all file sin /tsm/client!!!!

any other possible reasons?

 

[Harry_Redl]

Hi,

it is an permission issue - operating system is unable to write to file. Question is whether it is a log file for TDP (what is your errorlogname option?) or Oracle datafile ....
show us
/opt/tivoli/tsm/client/api/bin/dsm.opt
/opt/tivoli/tsm/client/oracle/bin/tdpo.opt

Harry

 

[mahmurth]

First to check.... when you kick off restore check whether the session established with TSM server, second thing, check the permissions for tdperr.log, as per your update you have already done this, but can u verify the permission using ls -lrt for all the files in the tdp path. As well, login with oracle user and by su - oracle and check showenv o/p..

 

[tsmdumber]

Thanks Guys. It was a permission issue with TDpoerrorlog. I was looking at the errorlog in the default location (. DumB DUMB DUMBER. .

but the error log was in a different diretory specified in TDPO.OPT.
DSMI_LOG /home/oraclebas/DBA-Scripts/tsm


Many many thanks for your help guys!!

Regards,
TSMDUMBER