First of all if you backup your db after stopping your Oracle service, your
backup is no good.
By default, stopping the service will abort your instance and your db files
will be inconsistent. Subsequent startup will recover them, however, if you
restore your db from your backup, and startup your instance, it will tell you
that you need recovery.
To change this default, you need to change your registry to tell Oracle service
to shutdown your instance with "immediate" parameter. How to do this is
described in Oracle Getting Started for NT.
To automate shutdown/startup you can use NT "at" command to schedule your CMD
script.
In this script you can issue command that shutdown or startup your instance.
You can use different commands. This is also described in the above manual.
You can use Oracle way:
svrmgr23 command@=shutdown.sql
where shutdown.sql contains:
connect internal/password
shutdown immediate
exit
This is exactly how Oracle will do if you change your registry.
You can also use ORADIM utility.
And, you can use NT commands:
net stop service name
net start service name
This is the same as doing it from control panel.
Received on Sat Oct 17 1998 - 08:18:42 CDT
