Re: ORASHUT.bat on 8i ?

You guys misunderstand me. I can start and stop the database. However WHEN the database is shutdown I need to run a script. By calling that script in orashut I get to run that script before the database is shutdown.

This is part of a cold backup solution that is running at small shops, that dont have a DBA or anybody that knows anything about Oracle. I made scripts that selects from v$datafile etc to know which files to backup when the database is shutdown.

Peter Laursen

"Brian Peasland" <oracle_dba_at_peasland.com> wrote in message news:3D91D9F0.AD6858AD_at_peasland.com...
> Peter,
>
> Instead of running a script to start/stop the db, just start/stop the
> service. For instance:
>
> net stop OracleServiceSID
>
> This can just be a line in your batch program.
>
> HTH,
> Brian
>
> Peter Laursen wrote:
> >
> > Hi,
> >
> > In 8.0.5 on Windoze there is a file orashut.bat that is called when the
> > database is shutdown. It starts svrmgr30 and does a shutdown by running
> > orashut.sql.
> >
> > I have build in some calls to my own scripts that needs to be run on
> > shutdown. How can I do this in 8.1.7 SE? Is there some solution that
will
> > run unchanged on 8.0.5, 8i and 9i all Windows OS?
> >
> > TIA
> > Peter Laursen
Received on Thu Sep 26 2002 - 02:25:54 CDT