Re: "Thou shalt use 'Shutdown Abort' whenever you shutdown the database." Makes sense?

In article <337dd193.2328728624_at_203.12.176.153>,

        gedau_at_mim.com.au (George Dau) writes:

>
>
>]I would recommend that they use a shutdown immediate, or if they must
>]shutdown abort, at least start the database backup and then shutdown
>]normal. The docs are pretty clear, shutdown abort is a last resort,
>]not a standard operating procedure.
>
>I think Thomas ment ... start the database back up and then shutdown normal,
>then start the database backup ...

Actually, I'd recommend the sequence:
shutdown immediate;
startup restrict;
shutdown normal;

If the 'immediate' doesn't take effect (by monitoroing of the alert log, then break it, shutdown abort, startup restrict (long enough to process all the outstanding redo), then shutdown normal.  

>
>There is no point doing a database backup after a shutdown abort.

... at least until the database is restarted, and all redo has been posted.

Bill

--