RE: Lost a redo disk

Never mind. I was able to open the database.

I renamed the redo file to a disk that is working, and then set the _allow_resetlogs_corruption parameter to true. Then I was able to do an open resetlogs.

But thanks anyway to anyone who's going to respond when my question hits the list.

Beth

> -----Original Message-----
> From: Seefelt, Beth
> Sent: Wednesday, February 20, 2002 8:28 AM
> To: 'ORACLE-L_at_fatcity.com'
> Subject: Lost a redo disk
>
>
> Hi everybody,
>
> This all started with the halon firing in our data center last night around 10pm so you can imagine my condition.
>
> I lost a disk that contained only redo logs.
>
> When I try to open the database I get
>
> ORA-00313: open failed for members of log group 1 of thread 1
> ORA-00312: online log 1 thread 1: 'F:\ORACLE\ORADATA\OWBREPOS\REDO01.LOG'
> ORA-27041: unable to open file
> OSD-04002: unable to open file
>
> I thought what I needed to do was switch the log files, drop the members that are on the bad disk, and then I'd be able to open the database.
>
> So I mounted the database and did
>
> alter system switch logfile;
>
> and its telling me ORA-01109: database not open
>
> I thought I could swicth logfile with the database mounted?
>
> Could someone suggest the right steps I should take to recover?
>
> Many TIA,
>
> Beth

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seefelt, Beth
  INET: Beth.Seefelt_at_TetleyUSA.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).