Start/Stop oracle 8.0.4 on NT

From: Yoram Nistor <yoram.n_at_hfa.zim.co.il>
Date: 7 Oct 1998 19:16:45 GMT
Message-ID: <01bdf218$526c2d40$f303010a@pc3496.hfa.zim>

                           Start/Stop oracle 8.0.4 on NT

As part of a batch job (every night) I have to perform :

*) Shutdown the database.
*) Execute cold backup.
*) Startup the database.

I don't know what is the best way to stop/start the database.

Options :

oradim80 -shutdown -sid aaa -userpwd bbb -shuttype srvc,inst -shutmode i "OS backup" oradim80 -startup -sid aaa -userpwd bbb -starttype srvc,inst -pfile c:\...
svrmgr30 ... net stop oeacleserviceAAA "OS backup" net start oracleserviceAAA svrmgr30 ...

ý3þ) Other way

If the answer is option no 2
please send my the full syntax and explanation of the svrmgr30 command.

As far as I know the syntax or version 7.3 is svrmgr23 @c:\...\...\shutdown.sql

where shutdown.sql contain :

	connect internal/password_at_2:orcl
	startup pfile=c:\...
	exit


                    regards 

                        yoram

Received on Wed Oct 07 1998 - 14:16:45 CDT