Re: "Thou shalt use 'Shutdown Abort' whenever you shutdown the database." Makes sense?
Date: 1997/05/03
Message-ID: <336AD20C.A0753A30_at_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 exceptas
<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> <A HREF="http://www.dejanews.com/">http://www.dejanews.com/</A> 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 CEST