Re: batch file for oracle

From: Dirk Mika <dirk.mika.dm1_at_bayer-ag.de>
Date: Tue, 18 Jan 2000 07:44:41 +0100
Message-ID: <38840BD9.B30A1B2F@bayer-ag.de>

Hi,

you could try this:

svrmgrl << EOF
connect internal
shutdown
EOF You should keep in mind that you can shutdown your database only with no connections open or you have to do a *shutdown immediate*.

After backup:
svrmgrl << EOF
connect internal
startup
EOF Regards

Dirk Mika

marishen_at_my-deja.com schrieb:
>
> how do you write a batch file to stop and start the oracle engines at a
> specific time in order to backup the database, etc?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jan 18 2000 - 00:44:41 CST