Thanks so much. I got the log sequence and thread. When I tried to
recover I got an write error which indicated that the archive directory
couldn't be written to. The SA fixed it and when I tried the recovery
again it worked and I was able to open the database.
-----Original Message-----
From: Greg Minor [mailto:Greg.[Email address protected]
Sent: Thursday, July 05, 2007 11:01 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
The most common method for DR is to use set until time. The syntax for
using set until time is
set until time="to_date('2006-12-04 10:00:00','YYYY-MM-DD HH24:MI:SS')"
I believe you should be able to use a different date/time format, but it
would follow the same method.
As for your current attempt, you need to check the current database for
any logs that may not yet be backed up, and apply them using the set
until syntax.
Greg
-----Original Message-----
From: Sikyala Raquel
[Email address protected]
Sent: Thursday, July 05, 2007 9:46 AM
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