Paul is wrong and Mark is right. To shut down your databases gracefully you
need a short AT script. Otherwise you're getting the equivalent of a
shutdown abort on shutdown with crash recovery every time you restart NT.
This is not a great idea.
Mark Wagoner <mwagoner_at_no.spam.iac.net> wrote in message
news:37d8ffe1.65102382_at_news.iac.net...
> On Fri, 10 Sep 1999 16:06:32 +0400, Paul Konoplianik
> <pavelev_at_dcos.mipt.ru> wrote:
>
> >No. During shutdown process NT sends stop request to Active Oracle
> >Instance services. All these services write cashed information on disk,
> >close all memory buffers etc. Then all services stoped NT restarts
> >computer.
> >
> >Database recovery runs when you turns off power on your NT server or
> >incorrectly shutdowns NT server by some other way.
> >
>
> This is incorrect. Shutting down NT without shutting down the databas
> first is the same as powering off the machine, as far as Oracle is
> concerned. You can very this by reviewing the alert log after the
> system comes back up. Oracle will report that it had to do a crash
> recovery at startup.
>
> Starting with Oracle 8, you can create a registy entry ORA_SHUTDOWN =
> TRUE. If this is set (the default is FALSE), Oracle will do a
> shutdown immediate when you manually stop the service through control
> panel. Unfortunately, this has no effect when you simply shutdown NT.
> You can get more info on this in manuals.
>
> --
> Mark Wagoner
> To reply, remove no.spam from my e-mail address
Received on Sun Sep 12 1999 - 14:49:17 CDT
