Re: Best way to handle Oracle shutdowns from Unix script

Hi ,
There is a script called dbstart and dbshut in $ORACLE_HOME/bin directory . You can call those scripts for startup and shutdown. This script dbshut do a shutdown abort if there are some client application running. If the script is not available , you can do as follows.

sqldba  lmode=y     ( if version 7.3 ++ svrmgrl in place of sqldba lmode=y
shutdown abort      -- shutsdown immediately
startup		   -- to make sure the database is consistent
shutdown	   -- to a shutdown for backup

If there are difficulties in syntax for the shell script , please revert back to me.

For help on imp imp/help=y will give the help.

Regards
Anbu

Mark Day <mday_at_ucla.edu> wrote in article <34429f2f.2579058_at_news.ucla.edu>...
> This is a real newbie question, but what is the best way to shutdown
> and startup the oracle server from a Unix script (running SCO
> Enterprise Server 3.0 with Oracle 7.1). I want to do a full system
> backup automatically on Saturday night, and so I want to create a
> script that I can run in cron that will shutdown the oracle server,
> run the backup program, and start the server up again. Are there
> concerns about someone leaving a client application running with a
> transaction partly finished when the shutdown happens?
>
> And by the way, how do you get help for programs like "exp" from the
> command line (i.e. something like "exp -?" that would give you the
> command line options).
>
> Thanks,
>
> Mark Day
>
>
  Received on Tue Oct 14 1997 - 00:00:00 CDT