Here is the log I get when I try and recover any part or the whole
database.

OS - Windows Server03
__________________________________________________ _____
Recovery Manager: Release 10.1.0.2.0 - Production



Copyright (c) 1995, 2004, Oracle. All rights reserved.



RMAN>

connected to target database: ORCL (DBID=1125366970)

using target database controlfile instead of recovery catalog



RMAN> 2> 3> 4> 5>

Starting restore at 23-AUG-06

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=159 devtype=DISK

released channel: ORA_DISK_1

RMAN-00571: ================================================== =========

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ================================================== =========

RMAN-03002: failure of restore command at 08/23/2006 14:52:02

ORA-19554: error allocating device, device type: SBT_TAPE, device name:


ORA-27211: Failed to load Media Management Library



RMAN>



Recovery Manager complete.
__________________________________________________ ________

What I get from that report is the Recovery Manager is trying to
recover the database from Tape. The backup is in the Flash Recovery
Area on a separate disk from the database on the same computer. I set
up the flash recovery area to be there and set the backups to go to the
flash recovery area. I didn't even configure the tape portion, and I
have had no problems backing up to disk, the backup of the database is
there. Note, I am a virgin to recovering a database, and I am using
Oracle Enterprise Manager to configure and to operate these procedures.
What is strange to me is when you configure the backup you can specify
a destination for the backup, but when you begin a restore there is no
way to specify a source for the backup. I can't find anywhere in
Enterprise Manager to configure where I want to restore from. Not a
location or a device such as from disk or tape. I'm not sweatting too
hard, this is a test database I'm using to get my feet wet. It doesn't
even need recovering, I just want to be sure I can do it, but this is
just kind of frustrating at the moment, and I know it's got to be some
easy thing. Also I am following instructions from an Oracle PDF called
2Day DBA, and that was the exact procedure for recovering, which came
after setting up backups and recovery and performing a backup. I also
should note I have enable archiving in the Recovery Settings.

On 23 Aug 2006 13:25:15 -0700, "heatrj@gmail.com" <heatrj@gmail.com>
wrote:

> I can't find anywhere in
>Enterprise Manager to configure where I want to restore from. Not a
>location or a device such as from disk or tape.


there is no need for that, as the location of the saveset is recorded
in the controlfile.
Try issuing the list backup of database command in rman and you will
see.

Could you post
- the exact commands
- the result of
show all

--
Sybrand Bakker, Senior Oracle DBA

Here is a show all

RMAN> show all;

using target database controlfile instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 31 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO
'%F'; # defa
ult
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM 1;
CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
# default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; #
default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; #
default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 7 G;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXPIECESIZE 7 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'C:\ORACLE\PRODUCT\10.1.0\DB_1\DATABASE\S
NCFORCL.ORA'; # default

heatrj@gmail.com schreef:

> Here is a show all
>
And now: what commands do you issue to restore? That is what Sybrand
asked you to post as well.

Frank van Bortel wrote:
> heatrj@gmail.com schreef:
>
> > Here is a show all
> >
> And now: what commands do you issue to restore? That is what Sybrand
> asked you to post as well.

My original post stated I am using Enterprise manager. Enterprise
Manager doesn't use RMAN commands. It is a web interface used to
administer the database.