Re: Lost a redo disk

Beth

Just for the record I hope that you understand that you have to do a full export and recreate the database and a full import into the newly created database to have a supported database. The parameter _allow_resetlogs_corruption grants you right's to open the database even it it needed recover from the missing redo log file.
The other thing to have in mind it that there is a possibility that you have lost committed transaction there was residing in the lost redo log :-(

/regards

Seefelt, Beth wrote:

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

-- 

/regards

Peter Gram

Phone : +45 2527 7107
Fax   : +45 4466 8856

Miracle A/S
Kratvej 2
2760 Målev
http://miracleas.dk




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Gram
  INET: peter.gram_at_miracleas.dk

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