Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: shutting down and restarting - for backup purposes

Re: shutting down and restarting - for backup purposes

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Fri, 4 Feb 2000 14:10:17 GMT
Message-ID: <389ADDC9.80E125E1@edcmail.cr.usgs.gov>


You can try:

   SVRMGR30 COMMAND=C:\somedir\batchfile.sql Then in batchfile.sql put the following lines:

   CONNECT INTERNAL/ORACLE
   SHUTDOWN IMMEDIATE (or STARTUP)

HTH,
Brian

Christoph Kukulies wrote:
>
> 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

--



Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my company!
Received on Fri Feb 04 2000 - 08:10:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US