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

There are three "ways" to shutdown an oracle instance:

1> normal
2> immediate
3> abort

The safest way is "shutdown normal".

The quickest way is "shutdown abort".
You are correct that there is a potential risk. You should only use this method if the "shudown immediate" did not work.

The question is "When do you know that 'shutdown immediate' did not work?". The answer to this question is relative to specific sites. Shutdowm immediate may take less than a minute to more than an hour. It depends on the transactions that require rollback. In most cases it is a judgement call of your DBA. [He should have complete understanding of your database accesses and transaction processing.]

Should you opted to "shutdown abort" anyway. Oracle engine will probably is come up at next boot time. It will perform an instance recovery. Uncommitted transactions will be rollback at this point.

Jeff Cerrafon

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
           jeff.cerrafon_at_bellsouth.co.nz (email address)
+64-9-357-5158 (Direct Line)       +64-21-685158  (Mobile Phone)
+64-9-357-1697 (Fax)               +64-21-685157  (Mobile Fax)          
           My Homepage => http://iconz.co.nz/~cerrafon <=
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



paul.amaral_at_fmr.com wrote:


> 

> HELP:


> 

> I have a question for the Oracle and Imaging gurus.

> 

> While auditing the FileNet (imaging application) installation at our site,

> I noticed a script that is quite disturbing. (shutdown.sql under

> /fnsw/local/oracle)

> 

> In this script I noticed a "shutdown abort" EVERY TIME the instance is

> shutdown. (also just before a backup is performed)

> 

> I escalated this matter to FileNet, and they said that a "shutdown abort

> does not impose any danger to the Oracle instance or to the backups".

> 

> As a DBA, I learned from Oracle that "shutdown abort" is a NO-NO except as

> a last resort. Did anything change since I last took my first and last DBA

> courses (about 8 years ago and about three years ago)?

> 

> Every bit of information I receive will be very beneficial in our

> negotiations with FileNet to change their script. Also, if you need

> further details, please drop me a line.

> 

> Thanks a lot.

> 

> Paul.

> 

> -------------------==== Posted via Deja News ====-----------------------

>       http://www.dejanews.com/     Search, Read, Post to Usenet