Re: Cold backup on Windows NT/2000

I run the following script on an 8.1.5 on NT 4.0(not sure about compatibility w2000).

shutdown.bat

sqlplus user/password_at_sid @g:\oracle\admin\sid\sdi.sql net stop OracleServiceSID

end shutdown.bat

Sdi.sql:

shutdown immediate;
exit

end sdi.sql

HTH, Jim

-----Original Message-----
From: Helmut Daiminger <hdaiminger_at_vivonet.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Monday, August 14, 2000 4:33 PM
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
>also send the HELP command for other information (like subscribing).
Received on Mon Aug 14 2000 - 18:47:27 CDT