- If Multiplexed , simply copy from the Mirror file
- If Loss After NORMAL Shutdown , SIMPLY
startup mount
alter database open resetlogs
- If Loss After ABNORMAL Shutdown (i.e. shutdown abort)
RESTORE "ALL" datafiles ONLY from a previous cold backup
startup mount
recover database until cancel;
Apply logs till the Last available one
alter database open resetlogs (to RE-Create the LOST online redo logs)
> -----Original Message-----
> From: Rachel Carmichael [SMTP:carmichr_at_hotmail.com]
> Sent: Wednesday, July 12, 2000 7:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Online redolog corrupt
>
> 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
Received on Fri Jul 14 2000 - 00:27:08 CDT
