You're using a backup controlfile, and as such you're going to need to
do an alter database open resetlogs. You'll also probably want to set a
point in time to recover to, because RMAN will continue to try to
recover log files since you are using a backup controlfile.

If your were using the original controlfile then the rman recover
database would bring the database to the current scn of the controlfile.
RMAN knows that you are using a backup controlfile and consequently it
doesn't know when to stop the recovery. You have to tell it using the
set until (time, scn, or loqseq) to get it to stop like

Set until scn 10025856;

In your current situation try to issues an alter database open
resetlogs. If it still tells you that media needs recovery then you'll
need to get any log files that may have been archived since you
performed the recovery.

Greg

-----Original Message-----
From: Sikyala Raquel
[mailto:oracledba-ezmlmshield-x26265660.[Email address protected]
Sent: Thursday, July 05, 2007 9:26 AM
To: LazyDBA Discussion
Subject: problem opening database

I did the following
startup nomount;
rman restore controlfile from autobackup; rman alter database mount;
rman restore database; rman recover database;

When I try to open the database I get an error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 07/05/2007 10:07:11
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u02/oradata/TEMS/sys_TEMS01.dbf'
How do I fix this?


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page