RMAN Recovery

  • From: "Rick Weiss" <RWeiss@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 03 May 2007 12:41:20 -0600

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: