Script for performing clean shutdown before windows shutdown

Hi all,
I need a script to perform a clean oracle shutdown every time that windows going to shutdown.I need this to be sure that there wont be any instance recovery every time I startup the oracle(Mostly I fear from header inconsistency and ...).
Is there any thing that I can deploy for my development sites?
-Your help will be so appreciated

What version of Oracle are you using?. Unlike Oracle 8.x, in Oracle 9.x shutting down Windows does SHUTDOWN IMMEDIATE.

Instance recovery happens at startup even if you manually shutdown the database, Oracle may not have to do any roll forward but it still needs to check it.

Thanks,
I am using 10g R1.Where is the documetation that says:

Quote:

---

in Oracle 9.x shutting down Windows does SHUTDOWN IMMEDIATE.

---

I do not have any problem with oracle startup checks,I want to sleep without the fear of not matching headers in datafiles!
-Regards

Look for ORA_SID_SHUTDOWNTYPE value in HKLM - Software - Oracle - Home for the current value, by default it is i for immediate.

Excuse me to repeat this more and more,but:
Is that registry value can ensure me,It will be cleanely shutdown oracle?
If yes then why there are a lot of "instance recovery" entries in alert.log(You have mentioned it is default)?
I startup oracle,then shutdown windows(Nothing done: any DML or ...) but there is still fair amount of "instance recovery" entries.
-Thanks

Oracle will be shutdown with IMMEDIATE clause. We use it and have no issues with it.

Post the Instance Recovery messages.

Hi,

Try using the oracle administration assistant for windows.
you can select the option for shutting down the instance using the immediate mode when the service is stopped. using shutdown immediate shouldn't usually pose problems. Instance recovery is not carried out on startup.

vikram

Hi,

Look for the ora_sid_shutdowntype key. If the value is a change it to i.
Oracle 9i uses immediate as the default mode.

Try performing a shutdown abort and a shutdown immediate.
Obviously abort is quicker, so u can guess which mode is being used by default.