Re: Startup and Shutdown Oracle 7.3 via Win-AT

From: <perfect_golf_at_my-deja.com>
Date: Wed, 18 Aug 1999 16:16:50 GMT
Message-ID: <7pem95$54d$1@nnrp1.deja.com>

In article <37baad11_at_news.uk.ibm.net>,
"Nicolas Bronke" <news_at_TRINITY.de> wrote:
> How can I start and stop the Oracle 7.3x database so that I can
perform a
> backup periodically?
>
> Thank you for any helpful hints
>
> Kindest regards
>
> Nicolas Bronke
>
> Hi Nicolas,

You can execute a .BAT job thru WIN-AT Command Scheduler.

Within the .BAT job you will execute the following commands:

cd /d c:\<place your directory path of the .sql file to be execute here> set oracle_sid=xxx
svrmgr23 @stopdb.sql

place your backup script here>>>

svrmgr23 @startdb.sql

Note: The xxx above related to your Oracle_SID that you want to communicate with. The example @stopdb.sql will be the SQL script that will connect and shutdown the appropriate database in question.

The stopdb.sql script will contain the following:

connect internal/yourpassword
shutdown
exit

Note: You might want to use shutdown immediate due to someone might still be logged on...

The startdb.sql script will contain the following:

connect internal/yourpassword
startup pfile=????
exit

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Aug 18 1999 - 11:16:50 CDT