Re: NOARCHIVELOG, ONLINE redolog corrupted - solved

its been at least a year since this wa sstated but i believe i read(have not tried it), that you could have totally erase your redo logs(like you had a serious failure in which all copies were lost) and a open restelogs would have recreated them. I think that was explained by someone on the list.

Would that have helped any?

joe
Rahul wrote:
>
> > list , (solaris, 8.1.6)
> >
> > two redolog thread, two member each, one member from each thread on raw
> >
> > while doing import (35 million rows), the raw member of thread 1 was not
> > available,
> > errors in alert log
> >
> > i dropped the raw member of thread 1, and continued import..
> >
> > lgwr crashed the instance, the ONLY member of the thread 1, (current,
> > online) got corrupted.
> >
> > tried to re-create the controlfiles WITHOUT the corrupted (online) ,
> > cannot as
> > that thread is required for recovery
> >
> > tried recovery until change (some SCN in the past) , recovery completed
> > BUT
> > open restlogs will return error. file nnnn requiure more media recovery
> > to be consistent.
> >
> > tried media recovery again.... error... unable to read block nnn ..unix IO
> > error
> >
> > set _allow_resetlogs_corruption = true
> >
> > ABLE TO OPEN THE DB (with errors in alert log) switched the log, dropped
> > the corrupted one..
> >
> > the _allow_reset parameter was the last resort... was their anything else
> > i could have tried ?
> >
> > regards
> > Rahul
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rahul
> INET: rahul_at_ratelindo.co.id
>
> 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)

-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: teci_at_the-testas.net

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