Dear All!

We have a problem below, pls help me. Thanks


1.  Installing TDP for Oracle 5.1.5 as instruction document to directory


    C:\Program Files\Tivoli\TSM\AgentOBA  of machine having IP address
192.168.131.7

     Before installing TDP, TSM backup client 5.1.5 was installed with
TSM API version 5.1.5.

     TSM server 5.1.5 was installed on PC with IP address
192.168.131.149



2.      Configuring TDP for Oracle following steps:



Define a  tdpo.opt file in the  directory  C:\Program
Files\tivoli\tsm\AgentOBA

with following content:

            DSMI_ORC_CONFIG    C:\Program
Files\tivoli\tsm\agentoba\dsm.opt

DSMI_LOG           C:\Program Files\tivoli\tsm\agentoba



tdpo_trace_flags orclevel0 orclevel1 orclevel2

tdpo_trace_file c:\Program Files\tivoli\tsm\agentoba\tdpo.out



Register the TDP for Oracle node to  TSM server :successful



Define a  dms.opt file  in the  directory  C:\Program
Files\tivoli\tsm\AgentOBA

with following content:

commmethod      tcpip

NODename bu4db

TCPPORT 1500

TCPServeraddress 192.168.131.149



tracefile c:\oracle\admin\rman\tsmapi.out

traceflag service



passwordaccess generate



Change to the  C:\Program Files\tivoli\tsm\AgentOBA directory and run

*       tdpoconf password command : successful
*       tdpoconf showenvironment : successful.

3.      Run RMAN backup script by command:

RMAN TARGET internal/(PasswordofInternal Acc)@Service RCVCAT
rman/rman@Service CMDFILE bkdb.scr MSGLOG bkdb.log



With service is database name



Content of bkdb.scr file :

run
{
 allocate channel t1 type 'sbt_tape' parms
  'ENV=(tdpo_optfile="C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt")';

   backup
      filesperset 5
      format 'df_%t_%s_%p'
      (database);

  }

4.       After running  RMAN script, in tdpoerror.log file having errror
information:

11/13/2003:23:13:14 TID<1132>  ==>  ANU2615E Options file '"C:\Program
Files\Tivoli\TSM\AgentOBA\tdpo.opt"' not found.

11/13/2003:23:13:14 TID<1132>  ==>  ANU0003S An internal processing
error has occurred

5.      In addition, bkdb.log file that was created by above  RMAN
command was following content :



Recovery Manager: Release 8.1.7.0.0 - Production



RMAN-06005: connected to target database: C27 (DBID=3208501663)

RMAN-06008: connected to recovery catalog database



RMAN> run

2> {

3>    allocate channel t1 type 'sbt_tape' parms

4>             'ENV=(tdpo_optfile="C:\Program
Files\Tivoli\TSM\AgentOBA\tdpo.opt")';

5>

6>    backup

7>       filesperset 5

8>       format 'df_%t_%s_%p'

9>       (database);

10>

11>   }

12>

13>

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

ORA-19511: SBT error = 7011, errno = 2534, sbtopen: system error

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



Recovery Manager complete.





Note: Using account admin. According to the prediction, no reading
tdpo.opt file resulted in failure.

  _____

Nguyen Duc Thanh
FPT Software Solution-Government Business Unit
Address: 3th Fl, 51th, Ledaihanh.str, Haibatrung.dst, Hanoi, Vietnam
Tel: (84-4) 974-5451/974-5476, ext 304
Fax: (84-4) 974-5475
Mobile: (090) 411-9847
Website: www.fpt.com.vn