> 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).
Received on Tue Jul 31 2001 - 23:52:55 CDT
