RE: Online redolog corrupt

I would 'alter system switch logfile' until the current one is not corrupted,
and then perform a hot backup.
And voila !

PS : And mirror my redo logs in the future !

> ----------
> From: David Barbour[SMTP:DBarbour_at_connectsouth.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, July 12, 2000 18:49
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Online redolog corrupt
>
> Rachel,
>
> Also got bit in 7.3.4 by this. Vijay notes that he's not mirroring. If
> he
> has a corrupt redo log, I think his only option will be to run a
> cancel-based recovery from backup.
>
> Probably ought to back the puppy up first before running a recovery.
>
> David A. Barbour
> Oracle DBA - ConnectSouth
> 512-681-9438
> dbarbour_at_connectsouth.com
>
>
> -----Original Message-----
> Sent: Wednesday, July 12, 2000 8:54 AM
> To: Multiple recipients of list ORACLE-L
>
>
> well, in 7.3.4, my database crashed and wouldn't reopen when I had a bad
> online log. And call Support -- although we couldn't get the database to
> reopen anyway... you could try to drop the logfile and do an open database
>
> resetlogs
>
>
>
>
> >From: Vijay Patidar <vpatidar_2000_at_yahoo.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Online redolog corrupt
> >Date: Wed, 12 Jul 2000 02:54:04 -0800
> >
> >Hi all,
> > I am asking this ques. only for my info.
> >Suppose my online redolog corrupt then ,what will be
> >the message given by database and what action should
> >be taken at this condition.
> >
> >My Oracle version is oracle 8i..
> >Database is running in archivelog mode.....
> >I doesn't have any mirror of redolog files.......
> >
> >Thanks and Regards
> >-- Vijay Patidar
> >
> >
> >
> >
> >__________________________________________________
> >Do You Yahoo!?
> >Get Yahoo! Mail - Free email you can access from anywhere!
> >http://mail.yahoo.com/
> >--
> >Author: Vijay Patidar
> > INET: vpatidar_2000_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).
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Rachel Carmichael
> INET: carmichr_at_hotmail.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).
> --
> Author: David Barbour
> INET: DBarbour_at_connectsouth.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
Received on Wed Jul 12 2000 - 18:34:10 CDT