Re: "Thou shalt use 'Shutdown Abort' whenever you shutdown the database." Makes sense?
Date: 1997/05/04
Message-ID: <5kh500$o4s_at_elmo.cadvision.com>#1/1
[Quoted] 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
--Received on Sun May 04 1997 - 00:00:00 CEST