RE: RMAN Recovery

  • From: "Richard J. Goulet" <rgoulet@xxxxxxxxxx>
  • To: <RWeiss@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 3 May 2007 15:22:46 -0400

You might try setting your default device type to disk thereby
eliminating the SBT_TAPE error.
 

........................................................................
............................................................. 
Kanbay <http://www.kanbay.com/> 
Dick Goulet, Senior Oracle DBA 
45 Bartlett ST | Marlborough, MA 01752 USA
Tel: 508.573.1978 | Fax: 508.229.2019 | Cell: 508.742.5795
rgoulet@xxxxxxxxxx <mailto:rgoulet@xxxxxxxxxx> 
........................................................................
............................................................. 


 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rick Weiss
Sent: Thursday, May 03, 2007 2:41 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RMAN Recovery


I finally get the chance to recover from a failure and it turns out to
be the worst kind - DW (NOARCHIVELOG)
 
10.2 on RedHat
 
I am using Robert's excellent RMAN book (which was delivered to me from
Amazon only a week ago), but my RMAN isn't cooperating. I have good
backups from a while back and have done these steps:
- Flushed the data files
- restored my control files
- startup mount; on the database
 
When I try to restore the database from disk backup, RMAN does this:
 
Recovery Manager: Release 10.2.0.1.0 - Production on Thu May 3 12:28:52
2007
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
 
RMAN> connect target /;
 
connected to target database: EDWPRD01 (DBID=2782310113, not open)
 
RMAN> allocate channel for maintenance device type disk;
 
using target database control file instead of recovery catalog
allocated channel: ORA_MAINT_DISK_1
channel ORA_MAINT_DISK_1: sid=409 devtype=DISK
 
RMAN> restore database;
 
Starting restore at 03-MAY-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=408 devtype=DISK
released channel: ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/03/2007 12:29:55
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
 
RMAN>

 
I am going to continue RTFM'ing, but was wondering if anyone has seen
this or know where I am missing the boat.
 
Thanks
 
 
 
Rick Weiss
Oracle Database Administrator
 
Student Assistance Foundation
P.O.Box 203101
2500 Broadway
Helena, MT 59620-3101
 
rweiss@xxxxxxxxx
(406) 495-7356

Other related posts: