Message-Id: <10558.112086@fatcity.com> From: "Thapliyal, Deepak" Date: Fri, 14 Jul 2000 10:06:27 -0700 Subject: RE: Online redolog corrupt to my understanding a reset log open will work "only" after and incomplete recovery. just a fyi ! -----Original Message----- From: VIVEK_SHARMA [mailto:vivek_sharma@inf.com] Sent: Friday, July 14, 2000 12:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: Online redolog corrupt 1) If Multiplexed , simply copy from the Mirror file 2) If Loss After NORMAL Shutdown , SIMPLY startup mount alter database open resetlogs 3) 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@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 > >Reply-To: ORACLE-L@fatcity.com > >To: Multiple recipients of list ORACLE-L > >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@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@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@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@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: VIVEK_SHARMA INET: vivek_sharma@inf.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@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