Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: dbshut script - shutdown or shutdown immediate

Re: dbshut script - shutdown or shutdown immediate

From: Daniel W. Fink <>
Date: Wed, 02 Apr 2003 11:20:03 -0800
Message-ID: <>

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

IOUG-A Live! April 27 - May 1, 2003 Orlando, FL
   Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL
   Thursday, May 1 1:00pm - 2:00pm - Automatic Undo Internals

GovindanK wrote:

>>Shutdown abort is pretty drastic, are you sure shutdown immediate didn't
>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.
-- Please see the official ORACLE-L FAQ: -- Author: Daniel W. Fink INET: Fat City Network Services -- 858-538-5051 San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: (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 Wed Apr 02 2003 - 13:20:03 CST

Original text of this message