Hi Raquel

As you mounted the database you can query the v$log to see the
current log sequence. Then you can use "set until sequence <seqence_number>;"
Then issue the alter database open resetlogs command.

Regards

Måns Axell
-----Original Message-----
From: Sikyala Raquel [mailto:oracledba-ezmlmshield-x87269554.[Email address protected]
Sent: Thu 7/5/2007 16:45
To: LazyDBA Discussion
Subject: RE: problem opening database

I tried the alter database open resetlogs and got the same error. I am trying to restore on a mirror server where the backup directory was copied to. As a result, I don't know how I could get the SCN or logseq number. I am testing a disaster recovery scenario.

________________________________

From: Greg Minor [mailto:Greg.[Email address protected]
Sent: Thu 7/5/2007 10:45 AM
To: Sikyala, Raquel
Subject: RE: problem opening database



**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as normal
**Anything below this line is the original email text


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
[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 <http://jobs.lazydba.com/> To Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
To unsubscribe: http://www.lazydba.com/unsubscribe.html







---------------------------------------------------------------------
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