Re: Using Shutdown Immediate

First a vote of thanks to Thomas Kyte for taking the time to research and give us the official, unofficial answer to the question of Shutdown Immediate.

Secondly. an anarchic view of Oracle databases:

The redo _is_ the database; the data files just happen to be a sloppy snaphshot that gets roughly re-synched from time to time so that very old redo logs can be discarded: the most robust part of Oracle _has_ to be the redo handling, or we could never trust Oracle to be a safe database at all:

        So:

What's wrong with doing a shutdown abort every time -- after all, if the suggested action after a shutdown abort is a startup/shutdown cycle, why is a backed up copy of the database (and its redo) any less likely to restart than the original that you've just shut down ?

NB: this is not an option I advise, but logically I can't find a fault with it.

-- 
Jonathan Lewis