Joe,
That's true, but only if the current logs are not
needed for instance or media recovery.
For example if you want to open from a cold backup and
you don't have the online logs you can fake recovery
and then open resetlogs and it will recreate them for
you:
startup mount
recover database until cancel
- you should get a message saying media recovery
complete or not needed since everything is already in
sync if it's a true cold backup
alter database open resetlogs;
You have to do the recover database until cancel to
"fake" an incomplete recovery so you can then open
with resetlogs; otherwise you'll get an error saying
resetlogs isn't needed.
Whenever you open with resetlogs, new logs will be
created if they don't exist. In fact a trick to get a
db open quicker when using resetlogs if you have a
large # of online log groups and members is to drop
all except the bare minimum (2 groups, 1 member each)
to open the db. Then once the db is open you can add
the additional members and groups.
HTH,
- Anita
- 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: A. Bardeen
INET: abardeen1_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 Fri Aug 03 2001 - 13:38:50 CDT