Re: Script for performing clean shutdown before windows shutdown

From: <bdbafh_at_gmail.com>
Date: 15 Aug 2005 08:17:35 -0700
Message-ID: <1124119055.886364.226290@g14g2000cwa.googlegroups.com>

Your fears are well founded.

Even with the service configured to perform a shutdown immediate when the service is stopped, if control is not returned within the "wait to kill service timeout" the process is terminated in a non-graceful fashion and crash recovery will be required ... possibly requiring media recovery to be performed.

best approach is to:

connect / as sysdba
alter system switch logfile;
shutdown abort
startup mount restrict
alter system set job_queue_processes=0;
alter database open;
shutdown immediate

then stop the operating system service.

you'll also want to alter the value for the registry key HKLM\SYSTEM\CurrentControlSet\Control\WaitToKillServiceTimeout the default is 20000 (20 seconds).
I'd recommend setting it to at least 300 seconds.

hth.

-bdbafh Received on Mon Aug 15 2005 - 10:17:35 CDT