Re: shutting down and restarting - for backup purposes

Use the pwd program (in your $ORACLE_HOME\bin directory - sorry can't remember exact name) to generate a password for internal. Your Oracle NT manual will explain more about this. This will allow you to connect internal via the svmgr30 program, and from there issue a shutdown immediate.

is it something like

$ORACLE_HOME\bin\svrmgr30 <<shutdown.sql

shutdown.sql -
connect internal;
shutdown immediate;
exit;

? That's not far off anyway. First thing to do though is get the internal password set. Plus don't forget to set env variables when you are working with batch files ($ORACLE_HOME, $ORACLE_SID and append bin directory to path).

hth
NeilC.

Christoph Kukulies wrote in message
<87dvaa$ded$1_at_nets3.rz.RWTH-Aachen.DE>...
>Stephen Tenberg <STenberg_at_fcs-usa.com> wrote:
>: Use the NT batch processor - "AT". Crude, but we use it for just this
>: purpose.
>
>Yeah, that's what we are already using to start the backup script.
>
>But my question was more Oracle centered: What command would I
>have to use? I have a vage idea to use something like SVRMGR30 but
>with what command line (to avoid prompting for a password when connecting
>etc.).
>
>
>: Steve
>
>: Christoph Kukulies <kuku_at_gil.physik.rwth-aachen.de> wrote in message
>: news:87ce94$mec$2_at_nets3.rz.RWTH-Aachen.DE...
>:>
>:>
>:> We are running a nightly backup on our Oracle server Machine (NT 4.0)
>:> and we would like to stop all database activity (shutdown the server
with
>:> all instances), run the backup (.bat script that is) and resurrect the
>: server
>:> with all instances again.
>:>
>:> How can this be done non-interactively?
>:>
>:> --
>:> Chris Christoph P. U. Kukulies kuku_at_gil.physik.rwth-aachen.de
>
>
>
>--
>--Chris Christoph P. U. Kukulies kuku_at_gil.physik.rwth-aachen.de
Received on Fri Feb 04 2000 - 08:18:45 CST