What does this have to do with archivelog mode? In the bizarre scenario in which you lose a log between the time you shut down and started up, you are screwed with or without archivelog mode.
-- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 2 Apr 2003, GovindanK wrote: > This topic is getting interesting once more. Lets contribute. > > >>Multiplexing redo logs has nothing to do with the archive mode. > > Take a situation wherein the db is in NOARCH mode with only one member per group > (default setup). The dba gives shutdown abort and upon starting for some reason the > active log could not be read for recovery. How would one perform a complete > recovery?. > > Let me know if you have a workaround. > > I am willing to learn. > > GovindanK > > -- > |XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX| > |You should treat others the way you want to be treated - Mahatma Gandhi| > |XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX| > > > "Daniel W. Fink" <[EMAIL PROTECTED]> wrote: > > >Multiplexing redo logs has nothing to do with the archive mode. Logs are > >multiplexed so that an error writing to one of the members in a group > >does not cause the instance to terminate. > > > >Myth - If you use disk mirroring, you don't need to multiplex your redo > >logs. > >Reality - Mirroring only protects from hardware failure. It will not > >protect you from accidental deletion of the log (been there, had to fix > >it!). > > > >-- > >Daniel W. Fink > >http://www.optimaldba.com > > > >GovindanK wrote: > > > >>>Shutdown abort is pretty drastic, are you sure shutdown immediate didn't > >>>work? > >>> � � > >>> > >> > >>Well said. This topic has been circulating in many DBA forums for a long time. > >>Shutdown immediate does rollback and will take time if no.of users > >>is high. On the otherside, shutdown abort simply takes the db down and > >>does not bother about anything else. As per manual, if you do a shutdown abort > >>then you WILL need the online redo logs for recovery just in case. > >>Think twice if your db is in NOARCHIVELOG mode. If your db is in ARCHIVE mode make > >>sure the logs are multiplexed. �Though Oracle's recovery seems > >>to be sturdy, double check your backup & recovery strategies. Also, which option > >>to use is influenced by how much downtime/shutdown time you can afford. > >> > >>HTH > >> > >>GovindanK > >> � > > > __________________________________________________________________ > Try AOL and get 1045 hours FREE for 45 days! > http://free.aol.com/tryaolfree/index.adp?375380 > > Get AOL Instant Messenger 5.1 for FREE! Download Now! > http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: GovindanK > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
