TDPO/RMAN backup error

[unixandtsm]

Hi all,

RMAN backup failed with below error. Any suggestion on how to solve this issue ?

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

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

Linux-x86_64 Error: 406: Unknown system error

Additional information: 7011

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

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

Thanks in advance!

 

[moon-buddy]

Has this been working before or is this a new install?

 

[unixandtsm]

Hi Ed,

This used to work earlier.

What are the files to look at when it comes to TDPO/RMAN config and errors ?

 

[moon-buddy]

This first thing to look and ask around for is - what changed?

Password expires and may need to be reset, etc.

 

[unixandtsm]

how and where to check if passwd is expired ?

 

[moon-buddy]

how and where to check if passwd is expired ?

There are two passwords - the TDP for Oracle password set at the dsmc prompt (dsmc -se=<TDP_Server_name>) and the TDPO password set at tdpoconf password.

To check if these are OK, login with dsmc -se=<TDP_Server_name> and if the password is OK, you will not be prompted.

The TDPO side should be checked by your DBA team. If they engage RMAN manually, they would know if the password has expired.

But, ask first if there has been any other changes before chasing after paswords.

 

[mccleld]

What @moon-buddy says and also I'd suggest running the 'tdpoconf showenv' utility to check that the TSM side of the TDPO configuration is all still setup correctly.

A common gotcha: check that the options files and any errorlogs they specify are still accessible by the user the RMAN backup script is invoked by - for example, the 'oracle' user rather than the 'root' user.

___________
David Mc
London, UK

 

[unixandtsm]

Hi Ed and David,

Now the backup is failing with

ANS1192E (RC959)  Specifying the error log '*' as a symbolic link is not allowed

below IBM link says that location specified for ERRORLOGNAME in dsm.sys should have write permissions but the file is having write permissions
http://www-01.ibm.com/support/docview.wss?uid=swg1IC46968

below is the part of dsm.sys

errorlogname            /var/opt/tivoli/tsm/log/dsmerror.log

and below are the permissions on the file specified above

-rw-rw-rw- 1 root root 266M Sep 11 05:19 /var/opt/tivoli/tsm/log/dsmerror.log

Please help on this.
Thanks in advance!

 

[moon-buddy]

When using TDP for Oracle, TSM is usually setup with a mulitple stanza DMS.SYS file. The location and name of the error.log file you specified, is it for the BA Client or for the TDP client?

 

[unixandtsm]

Hi Ed,

Not sure, because there is only one entry in dsm.sys file for errorlogname.
Below is the dsm.sys file

SErvername  TSM_ BA
   COMMmethod         TCPip
   TCPPort            1500
   Passwordaccess     generate
  * nodename           <node_name>
   TCPServeraddress   <tsm_server_name>


SErvername  TSM-Oracle
PASSWORDACCESS PROMPT
QUERYSCHEDPERIOD 12
NODENAME node_name
   COMMmethod         TCPip
   TCPPort            1500
   TCPServeraddress   <tsm_server_name>

*nodename               YourNameHere
resourceutilization     10
commrestartduration     10
commrestartinterval     120
compression             yes

errorlogname            /var/opt/tivoli/tsm/log/dsmerror.log
errorlogretention       30 d

schedlogname            /var/opt/tivoli/tsm/log/dsmsched.log
schedlogretention       30 d
inclexcl                /opt/tivoli/tsm/client/config/dsmc/inclexcl.dat
largecommbuffers        yes
maxcmdretries           2
memoryefficientbackup   no
*passwordaccess         generate
*passwordaccess          prompt
password                client
queryschedperiod        2
retryperiod             1

schedmode               prompt
tcpbuffsize             32
tcpnodelay              no
tcpwindowsize           32
txnbytelimit            25600
tcpnodelay              no
managedservices         schedule webclient

 

[tsmdumber]

did you check the permission in tdpoerror.log

i made the same mistake sometime back!

http://adsm.org/forum/showthread.php?23253-Oracle-restore&highlight=tsmdumber

 

[unixandtsm]

Back to the first error again

ORA-19554: error allocating device, device type: SBT_TAPE, device name: 
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
Linux-x86_64 Error: 2534: Unknown system error
Additional information: 7011
ORA-19511: Error received from media manager layer, error text:
   SBT error = 7011, errno = 2534, sbtopen: system error

 

[moon-buddy]

Back to the first error again

ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
Linux-x86_64 Error: 2534: Unknown system error
Additional information: 7011
ORA-19511: Error received from media manager layer, error text:
   SBT error = 7011, errno = 2534, sbtopen: system error

Can you check how many channels the DBA set RMAN for? You many need to enter a RESOURCEUTILIZATION value at the TDP stanza to avoid this error:

RESOURCEUTILIZATION <some_value_up_to_10>

 

[meurnt]

This error seems oracle package was installed without a license file, can you please verify the license file(agent.lic) under your tdpo installation path..
If it missed, install new oracle tdpo package or copy license file from other valid server

Thanks
Krish
Http://www.tsmguide.co.cc

 

[iscadmin]

Hi There,

Even I am facing same error for our TDP environment. We have IBM Spectrum protect and Oracle TDP configured on AIX.
Earlier also was facing same issue some two weeks back. Then we have changed path for it so it worked fine till day before yesterday and since yesterday its failing.

Error:
ORA-19554: error allocating device, device_type: SBT_TAPE, device_name:
ORA-27211: Failed to load Media Management Library

Thanks,
Vivek Kadam
Pune, IND

 

[moon-buddy]

Check the paths and if there are sufficient mount points.

On the TSM server set the mountlimit to a higher value for the TDP node.

 

[iscadmin]

Thanks.... It worked \m/