Yeah, thank, I change to '( EVN=tdp_outfile=C:\... )'without " or ' in
Script file and pass old trouble but now it have new problem : when
execute backup command in script, RMAN raise this error :
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-08030: allocated channel: t1
RMAN-08500: channel t1: sid=13 devtype=SBT_TAPE
RMAN-08526: channel t1: Tivoli Data Protection for Oracle: version
5.2.0.0
RMAN-03022: compiling command: backup
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: backup
RMAN-03014: implicit resync of recovery catalog failed
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001:
target database not found in recovery catalog
Recovery Manager complete.
_____
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
Juan Manuel Lopez Azañon
Sent: Friday, November 14, 2003 6:45 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Can't backup oracle with TDP 5.1.5 on windows 2000 server
Also try C:\progra~1\... Can be the reason why .
I hope this help you to resolve your little trouble.
Juan Manuel López
UNIX & Storage Administrator
ING National Nederlanden
Madrid. Spain
Por favor, responda a "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Enviado por: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Destinatarios: ADSM-L AT VM.MARIST DOT EDU
CC:
Asunto: 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
|
