Xref: alice comp.databases.oracle.server:26504
Path: alice!news-feed.fnsi.net!oleane!newsfeed.nacamar.de!rill.news.pipex.net!pipex!sun4nl!newsfeed.news.big-orange.net!feed.news.big-orange.net!not-for-mail
From: schluck@gironet.nl (Paul Schluck)
Newsgroups: comp.databases.oracle.server
Subject: Re: Starting Database using Cron
Date: Sat, 08 Aug 1998 06:23:11 GMT
Organization: gironet
Lines: 31
Message-ID: <35cbeca8.1884888@news.gironet.nl>
References: <35CBB084.83CDA39E@interramp.com> <6qgm5h$ei6$1@orthanc.reference.com>
X-Trace: rumba.admin.big-orange.net 902561173 28339 172.22.0.81 (8 Aug 1998 07:26:13 GMT)
X-Complaints-To: newsmaster@admin.big-orange.net
NNTP-Posting-Date: 8 Aug 1998 07:26:13 GMT
X-Newsreader: Forte Free Agent 1.11/32.235
Cache-Post-Path: tango.news.big-orange.net!unknown@27.131.dialin.mxs.nl

On 8 Aug 1998 05:02:41 GMT, mjain@bigfoot.com wrote:

>The CRON job is not the solution in this scenario.
....
....

>CRON job wont work because CRON jobs are specified to occur

>at fixed/seleced points in times. Generally OS startup and

>shutdown is not fixed in time. Moreover, OS shutdown is

>almost all cases manual process. So you need a solution which

>is event driven based on operating system bootup or shutdown.

I am a little puzzled about these remarks. At our site we do a full
system backup each night. The backup is scheduled using CRON with an
entry in the crontab like:

0 1 * * * /sb/bin/backup

In this backup script several other scripts are started, the first
being su - oracle -c dbshut and the last being su - oracle -c dbstart.
The dbshut and dbstart scripts are the one's provided by ORACLE in the
$ORACLE_HOME/bin directory. This has worked since years and I realy
don't see your problem. I would welcome a reaction

Kind regards

Paul Schluck (schluck@gironet.nl)