AW: Cold backup on Windows NT/2000

From: Schoen Volker <v.schoen_at_inplan.de>
Date: Wed, 16 Aug 2000 12:00:59 +0200
Message-Id: <10591.114696@fatcity.com>

Try to pub the "connect internal" into the SQL-Script.

Volker Sch=F6n
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

-----Urspr=FCngliche Nachricht-----
Von: Helmut Daiminger [mailto:hdaiminger_at_vivonet.com] Gesendet: Dienstag, 15. August 2000 02:18 An: Multiple recipients of list ORACLE-L Betreff: Cold backup on Windows NT/2000

> Hi all!

>=20

> I just "inherited" an Oracle 8.1.6 development database on=20
> Windows 2000
> Advanced server.
> First thing that I wanna incorporate is a cold backup=20
> procedure. Now I'm
> having doubt about how to do that in Windows 2000:

>=20

> I understand that if I use "net stop" this will stop the=20
> Windows service
> (which is a shutdown abort). So this is not going to work.

>=20

> I was thinking that I call svrmgrl and pass it some=20
> parameters, e.g. connect
> internal and the script that I wanna run after the logon. But=20
> how do I do
> that?

>=20
> svrmgrl "connect internal/oracle" works fine. But if I also add like =
a
> script that I wanna run after the login, it is not executed: svrmgrl
> "connect internal/oracle @shutdown.sql"

>=20

> Any ideas?

>=20

> Thanks,
> Helmut

>=20

> PS: Would it also be an option to use the good old "oradim"=20
> utility? This
> should do a clean shutdown of the database, right? Of course,=20
> you would have
> to hardcode passwords in there, right?

--=20
Author: Helmut Daiminger
  INET: hdaiminger_at_vivonet.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Aug 16 2000 - 05:00:59 CDT