Re: Script for performing clean shutdown before windows shutdown

<bdbafh_at_gmail.com> wrote in message
news:1124119055.886364.226290_at_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
>

DO NOT SHUTDOWN ABORT If you're that fearful, execute a SHUTDOWN IMMEDIATE manually every time you wish to stop or restart the OS. Don't rely on scripts to do it for you because scripts can fail.

-- 

Andreas Sheriff
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer
----
"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding, if you don't eat your meat?"

DO NOT REPLY TO THIS EMAIL
Reply only to the group.