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

Home -> Community -> Usenet -> c.d.o.misc -> Re: "Thou shalt use 'Shutdown Abort' whenever you shutdown the database." Makes sense?

From: oracle <oracle_at_nightmare.com>
Date: 1997/05/03
Message-ID: <336AD20C.A0753A30@nightmare.com>#1/1

--------------63A47AD7024447BC90932FDF
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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)?
> http://www.dejanews.com/ Search, Read, Post to Usenet

I always do this myself but then start the database again and do a normal shutdown to clean up on the logs before doing a cold backup. If you look at the lightsout.sh shell script that oracle provides with EBU it does the same thing.

--------------63A47AD7024447BC90932FDF
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<HTML><BODY>
paul.amaral_at_fmr.com wrote:

<BLOCKQUOTE TYPE=CITE>HELP:
<BR>
<BR>I have a question for the Oracle and Imaging gurus.
<BR>
<BR>While auditing the FileNet (imaging application) installation at our site,
<BR>I noticed a script that is quite disturbing. (shutdown.sql under
<BR>/fnsw/local/oracle)
<BR>
<BR>In this script I noticed a "shutdown abort" EVERY TIME the instance is
<BR>shutdown. (also just before a backup is performed)
<BR>
<BR>I escalated this matter to FileNet, and they said that a "shutdown abort
<BR>does not impose any danger to the Oracle instance or to the backups".
<BR>
<BR>As a DBA, I learned from Oracle that "shutdown abort" is a NO-NO except

as
<BR>a last resort. Did anything change since I last took my first and last DBA
<BR>courses (about 8 years ago and about three years ago)? <BR>      http://www.dejanews.com/     Search, Read, Post to Usenet
</BLOCKQUOTE>
 I always do this myself but then start the database again and do a normal shutdown to clean up on the logs before doing a cold backup.  If you look at the lightsout.sh shell script that oracle provides with EBU it does the same thing. 

</BODY>
</HTML>

--------------63A47AD7024447BC90932FDF-- Received on Sat May 03 1997 - 00:00:00 CDT