Re: NT Batch file to backup database

Jeff Kish <ait_at_concentric.net> schrieb im Beitrag <33fcca4a.37144571_at_news.concentric.net>...
> Please pardon this probably oft asked question. I perused the groups
> but did not see it here.
>
> I have an Oracle 7.3 database. It is running on NT 3.51.
> Does anyone have a batch command I could use to shut down the
> database, fire up the scheduler to do a backup, and then to restart
> the database?
>
> I am already doing the scheduler part, but am not sure about the
> shutdown/startup from the commandline.
>
> Thanks, any pointers are appreciated
>
> Jeff Kish
> ait_at_concentric.net
>

Hallo,

I've already posted this earlier but here once more:

You must create a ASCII-File (z.B. shutdown.txt) with all the connect stuff in it:

connect internal/password_at_Connectstring
shutdown immediate

and call from your patch file svrmgr23 < shutdown.txt

Alos create a ASCII-File (z.B. startup.txt)

connect internal/password|Connectstring
startup pfile=...

and call from your patch file svrmgr23 < startup.txt

The same works for the listenercontrol if you'd like to shut the listener (be aware of set password).

Hope this helps

Helmut Received on Fri Aug 22 1997 - 00:00:00 CDT