Re: Script for performing clean shutdown before windows shutdown

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Mon, 15 Aug 2005 18:04:50 +0200
Message-ID: <ddqef3$pfa$1@news.BelWue.DE>

Andreas Sheriff wrote:

> <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.
> 

Only that SHUTDOWN IMMEDIATE might wait a long time if, e.g. the Intelligent(?) Agent is running.... So scripting isn't too bad, provided you know the limitations.

In general shutting down everything that connects to the database (Intelligent Agent, DBConsole/EnterpriseManager....) should be shutdown first, then the database, and finally the listener (although the listener can be shutdown upfront to prevent logins).

On a busy database you might still have problems with shutdown immediate, though.

And if you don't trust Oracle to recover from a shutdown abort, don't use Oracle. Or invest in proper HW, OS and training.

Regards,
Holger Received on Mon Aug 15 2005 - 11:04:50 CDT