Joe ,
I think you are thinking about
ALTER DATABASE CLEAR LOGFILE ;
command . There is some catch to it .
The execrpt from OManual
"
Do not use CLEAR LOGFILE to clear a log needed for
media recovery. If it is necessary to clear a log
containing redo after the database checkpoint, you
must first perform incomplete media recovery. The
current redo log of an open thread can be cleared. The
current log of a closed thread can be cleared by
switching logs in the closed thread.
"
Cheers,
RS
--- Joe Testa <teci_at_the-testas.net> wrote:
> 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).
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sakthi , Raj
INET: rajan_sakthi_at_yahoo.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).
Received on Wed Aug 01 2001 - 15:36:41 CDT
