RE: RMAN Recovery

From: Richard J. Goulet <rgoulet_at_kanbay.com>
Date: Thu, 3 May 2007 15:22:46 -0400
Message-ID: <C3EE2ADD31ACF64DAB1B236044A1968D730820@miaexc01.kanbay.com>

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_at_kanbay.com <mailto:rgoulet_at_kanbay.com> 
........................................................................
............................................................. 


 

________________________________

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rick Weiss Sent: Thursday, May 03, 2007 2:41 PM
To: oracle-l_at_freelists.org
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

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_at_safmt.org
(406) 495-7356

--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 03 2007 - 14:22:46 CDT