Re: Lost a redo disk

"Seefelt, Beth" wrote:
>
> 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

Beth,

  The commands you usually play with when your database is not opened are variations on the ALTER DATABASE theme.   It looks like what used to be the current log file has been damaged, and quite obviously this occurred before the checkpoint.   If you have members on a good disk, what I'd try to do is to overwrite bad members with the corresponding good ones - they are supposed to be identical - then try to open the database. It may work.

If it still fails, I were you I'd probably try this BUT BEWARE THAT IT MAY MEAN LOST TRANSACTIONS :

1. Drop and recreate damaged members while the database is mounted with ALTER DATABASE
2. Open the database with the RESETLOGS options. In effect, it will mean that all transactions since the latest checkpoint are lost.

-- 
Regards,

Stephane Faroult
Oriole Ltd
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.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).