Can't backup oracle with TDP 5.1.5 on windows 2000 server
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_CONFIGC:\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/[EMAIL PROTECTED] 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 TID1132 == ANU2615E Options file 'C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt' not found. 11/13/2003:23:13:14 TID1132 == 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 { 3allocate channel t1 type 'sbt_tape' parms 4 'ENV=(tdpo_optfile=C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt)'; 5 6backup 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
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: [EMAIL PROTECTED] @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_CONFIGC:\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/[EMAIL PROTECTED] 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 TID1132 == ANU2615E Options file 'C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt' not found. 11/13/2003:23:13:14 TID1132 == 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 { 3allocate channel t1 type 'sbt_tape' parms 4 'ENV=(tdpo_optfile=C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt)'; 5 6backup 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
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 [EMAIL PROTECTED] Enviado por:ADSM: Dist Stor Manager [EMAIL PROTECTED] Destinatarios:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] @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_CONFIGC:\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/[EMAIL PROTECTED] 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 TID1132 == ANU2615E Options file 'C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt' not found. 11/13/2003:23:13:14 TID1132 == 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 { 3allocate channel t1 type 'sbt_tape' parms 4 'ENV=(tdpo_optfile=C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt)'; 5 6backup 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
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:[EMAIL PROTECTED] On Behalf Of Carsten Moldrup Sent: Friday, November 14, 2003 6:38 PM To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] @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_CONFIGC:\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/[EMAIL PROTECTED] 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 TID1132 == ANU2615E Options file 'C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt' not found. 11/13/2003:23:13:14 TID1132 == 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 { 3allocate channel t1 type 'sbt_tape' parms 4 'ENV=(tdpo_optfile=C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt)'; 5 6backup 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
Re: Can't backup oracle with TDP 5.1.5 on windows 2000 server
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 { 3allocate channel t1 type 'sbt_tape' parms 4 'ENV=(tdpo_optfile=C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt)'; 5 6backup 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:[EMAIL PROTECTED] On Behalf Of Juan Manuel Lopez Azaon Sent: Friday, November 14, 2003 6:45 PM To: [EMAIL PROTECTED] 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 Lpez UNIX Storage Administrator ING National Nederlanden Madrid. Spain Por favor, responda a ADSM: Dist Stor Manager [EMAIL PROTECTED] Enviado por:ADSM: Dist Stor Manager [EMAIL PROTECTED] Destinatarios:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] @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_CONFIGC:\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/[EMAIL PROTECTED] CMDFILE bkdb.scr MSGLOG bkdb.log With service is database name Content of bkdb.scr file : run { allocate channel t1 type
Re: Can't backup oracle with TDP 5.1.5 on windows 2000 server
Two Problems here: First off, you need to register the target database with RMAN - that should take care of your last error. Secondly, you need to put the key word TDPO_OPTFILE in all caps. Although, it appears to work for you, I can assure it is not. The 'ENV=()'; command in RMAN puts the contents inside the parentheses to the environment (putenv()). DP for Oracle does a getenv() on TDPO_OPTFILE which means that if that does not match exactly we do not recognize the parameter. The reason why it appears to work is that by default we look in the installation directory for the tdpo.opt file. The allocate channel command should look like this: allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=C:\Program Files\Tivoli\Tsm\AgentOBA\tdpo.opt)'; Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED]