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
|