Wednesday 14 August 2013

TDP Option File Error during Oracle Backup ;SBT error = 7011, errno = 2534, sbtopen: system error



I found this issue when dealing with Oracle DB backup where backup of multiple DB instances failed with SBT error = 7011, errno = 2534, sbtopen: system error.

Symptoms:

Database Buffers 327680000 bytes
Redo Buffers 532480 bytes
Database mounted.
SQL> Disconnected from Oracle8i Enterprise Edition Release <Release Number>
With the Partitioning option

Enterprise Edition Release <Release Number> 

===========================================================================================
Starting rman whole backup for <DB Instance Name> Level 2 Wed Jul 31 23:02:11 METDST 2013
===========================================================================================
Oracle8i

Recovery Manager: Release Enterprise Edition Release <Release Number> 

RMAN-06005: connected to target database: <Instance name>

(DBID=ID_Number)
RMAN-06008: connected to recovery catalog database

RMAN> 2> 3> 4> 5> 6>
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03007: retryable error occurred during execution of command: allocate
RMAN-07004: unhandled exception during command execution on channel t1
RMAN-10035: exception raised in RPC: ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-19557: device error, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
HP-UX Error: 2534: Unknown system error
Additional information: 7011
ORA-19511: SBT error = 7011, errno = 2534, sbtopen: system error
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.DEVICEALLOCATE
==================================


 We notice that In Script to run the Oracle offline DB backup , the path to TDP Oracle option file was not correctly mentioned which leads to option file error.

SBT error = 7011, errno = 2534, The error 2534 correspond to the TDP message =>

ANU2534E Option file error

We checked in RMAN script that  $TDP8i_DIR is not set to tdpo option file under /usr/tivoli/tsm/client/oracle/bin64 instead it was set to /usr/tivoli/tsm/client/oracle/bin.


/usr/tivoli/tsm/client/oracle/bin64 # cd $TDP8i_DIR
/usr/bin/ksh: /usr/tivoli/tsm/client/oracle/bin:  not found.

Solution: Set the correct path of tdpo option file in parameter $TDP8i_DIR so that it should look for tdpo option file under usr/tivoli/tsm/client/oracle/bin64.

You can also use tdpoconf showenv -tdpo_optfile=/location of opt file/ to see if there is any issue.

1 comment:

  1. Not seeing your RMAN command script here. Generally I explicitly define the location of tdpo when allocating the channel.

    allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/home/oracle/scripts/rman/tdpo.opt)' MAXPIECESIZE 4g;

    ReplyDelete