Re: Can't backup oracle with TDP 5.1.5 on windows 2000 server

Yeah, but when we change it to C:\tdpo.opt, it's the same problem, other
idead ?
And I sure that path to tdpo.opt  is correct.

  _____

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


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Carsten Moldrup
Sent: Friday, November 14, 2003 6:38 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Can't backup oracle with TDP 5.1.5 on windows 2000 server


Hi there

The space in the path name C:\program files\.... may be the reason.
put
the path/filename into " "

regards, Carsten


------------------------------------------------------------------------
----------------

This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit
written agreement or government initiative expressly permitting the use
of e-mail for such purpose.
------------------------------------------------------------------------
----------------





                      Thanh Nguyen Duc
                      <thanhnd                 To:
ADSM-L AT VM.MARIST DOT EDU
                      @FPT.COM.VN>             cc:
                      Sent by: "ADSM:          Subject: Can't backup
oracle  with TDP 5.1.5 on windows 2000 server
                      Dist Stor
                      Manager" <ADSM-L


                      14-11-03 12:28
                      Please respond
                      to "ADSM: Dist
                      Stor Manager"






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