RE: Cold backup on Windows NT/2000

Stopping the service is not necessarily shutdown abort. There are registry parameters that control the behavior. See chapter 7 of the admin guide for Winnt. I think that you can set

ORA_SID_SHUTDOWN='TRUE' (default is FALSE) ORA_SID_SHUTDOWNTYPE='I' (the default, or 'N' or 'A')

and then stopping the service will do shutdown immediate

ORA_SID_SHUTDOWN_TIMEOUT supposedly controls the time (in seconds) to wait for the instance to shut down.

HTH, Dr. Nikolay Kumanov

MIS Manager, Zeitungsgruppe Bulgarien GmbH 47, Tsarigradsko chaussee, Sofia 1504, Bulgaria phone: +(359-2)4339-643, fax: +(359-2)946-1286 mailto:nkumanov_at_zgb.bg

"Show me a completely smooth operation and I'll show you someone who's covering mistakes. Real boats rock." - Frank Herbert, "Chapterhouse: Dune"

-----Original Message-----
From: Helmut Daiminger [mailto:hdaiminger_at_vivonet.com] Sent: Tuesday, August 15, 2000 3:18 AM
To: Multiple recipients of list ORACLE-L Subject: Cold backup on Windows NT/2000

> Hi all!
>
> I just "inherited" an Oracle 8.1.6 development database on
> Windows 2000
> Advanced server.
> First thing that I wanna incorporate is a cold backup
> procedure. Now I'm
> having doubt about how to do that in Windows 2000:
>
> I understand that if I use "net stop" this will stop the
> Windows service
> (which is a shutdown abort). So this is not going to work.
>
> I was thinking that I call svrmgrl and pass it some
> parameters, e.g. connect
> internal and the script that I wanna run after the logon. But
> how do I do
> that?
>
> 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"
>
> Any ideas?
>
> Thanks,
> Helmut
>
> PS: Would it also be an option to use the good old "oradim"
> utility? This
> should do a clean shutdown of the database, right? Of course,
> you would have
> to hardcode passwords in there, right?

-- 
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