Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> RMAN error ORA-19511: SBT-7009

RMAN error ORA-19511: SBT-7009

From: Mark Malakanov <markmal-removethisantispammer_at_rogers.com>
Date: Mon, 02 Sep 2002 00:59:21 GMT
Message-ID: <JJyc9.67305$GK2.58156@news02.bloor.is.net.cable.rogers.com>

Following script does not work. Somewhere in the middle of process in gets an exception.
However, when I issue commands manually, I can repeat a particular command which failed and it works.
Oracle support fingerpoints on CA (vendor of ArcServe2K), claiming that it is the Media Manager error.
However I have found similar problems exist also for another backup software. People fix these by setting some environment vars. It does not help with ArcServe2K Media Manager.

Please help if you know solution.



Recovery Manager: Release 8.1.7.4.1 - Production Oracle 8.1.7.4
Backup software - ArcServe2000

Script

2>
3> # recreate dirs
4> host 'mkdir J:\LAWSONDATA';
5> host 'mkdir J:\LAWSONINDEX';
6> host 'mkdir J:\LAWSONTEMP';
7>
8> # restore datafiles
9> run {
10> allocate channel t1 type 'SBT_TAPE';
11> recover datafile 'J:\LAWSONDATA\DATA3.DBF' check logical;
12> recover datafile 'J:\LAWSONINDEX\INDEX2.DBF' check logical;
13> recover datafile 'J:\LAWSONTEMP\TEMPPROD.DBF' check logical;
14>
15> recover database;
16>
17> open database;

18>
19> }

Error appears on recovering of second file.

Error stack.

RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03007: retryable error occurred during execution of command: IRESTORE
RMAN-07004: unhandled exception during command execution on channel t1
RMAN-10032: unhandled exception during execution of job step 2: ORA-19624:
operation failed, retry possible
ORA-19507: failed to retrieve sequential file, handle="19e06njt_1_1", parms=""
ORA-27007: failed to open file
ORA-19511: SBT error = 7009, errno = 1459187408, sbtopen: can't connect with media manager
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 1157 ORA-06512: at line 81
RMAN-10035: exception raised in RPC: ORA-19624: operation failed, retry possible
ORA-19507: failed to retrieve sequential file, handle="19e06njt_1_1", parms=""
ORA-27007: failed to open file
ORA-19511: SBT error = 7009, errno = 1459187408, sbtopen: can't connect with media manager Received on Sun Sep 01 2002 - 19:59:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US