Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Script for performing clean shutdown before windows shutdown

Re: Script for performing clean shutdown before windows shutdown

From: HansF <News.Hans_at_telus.net>
Date: Fri, 26 Aug 2005 21:48:40 GMT
Message-Id: <pan.2005.08.26.21.52.47.32376@telus.net>


On Fri, 26 Aug 2005 14:10:08 -0700, Andreas Sheriff interested us by writing:

> What do you think would happen if Oracle were in the middle of writing to a
> block when you issue SHUTDOWN ABORT?

A transaction is only marked as 'committed' when it's been successfully written to the redo log. If it's not completed the write the database will simply rollback the transaction that is incomplete on restart of the database. (Confirmed in the Administrator's manual, Redo Log chapter.)

And also realize that we do not care whether any datafile blocks have been written, as that info can always be reproduced by the log file entries. The exceptions to this may start with the new 10gR2 'COMMIT WRITE NOWAIT' feature.

An abort is therefore is no biggie from the database's point of view, however users might get annoyed if they find out everything except the last write was complete.

So unless it's an issue with the operating system, so far it really doesn't matter much whether you shutdown abort. What does matter is what happens immediately after the shutdown abort ...

For example, it does matter whether you take a cold backup of the aborted database, especially if the database is in NOARCHIVELOG mode. A rule of thumb is that, as soon as feasible, an aborted database should be reopened and shutdown 'properly' to ensure the control file and the data files are properly synchronized.

All that said, I agree with the earlier statement that shutdown abort should only be used when there is an abnormal situation. It's a last resort, and even discussed that way in the Administrator's Guide http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/start.htm#6398

(This has been discussed many, many times in this list. Check the archives before 2003 for discussions by Howard Rogers.)

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***
Received on Fri Aug 26 2005 - 16:48:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US