Re: stopping oracle database via batch-file

it depends.

Specifically it depends on what shutmode has been set with the oradim utility on database creation - in most cases this will be a - for abort. You can however set it to either i for immediate or n for normal.

You can find out what it is set to by either looking in the registry or just examining the alert log as you would on any other platform.

If you really need a clean shutdown then I would be tempted to use a simple sql script to issue shutdown abort;, startup and then shutdown normal;. Most probably you don't actually need a scripted way to shutdown the database at all, but rather want to move to hot backup. .

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"tom" <t.p.sapbasis_at_gmx.net> wrote in message
news:b32q8j$jcb$1_at_lore.csc.com...


> hello,

>

> i'd like to know if the windows command net stop <oracleinstance - in my

> case SAP<SID>_XX > performs a clean shutdown of the database or crashes

it?


>

> can someone help me to find informations about that?

> thanx

> tom

>