Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORASHUT.bat on 8i ?
Thx Norman,
You are not missing anything. Its me thats missing half my brain ;-)
/Peter
"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
news:E2F6A70FE45242488C865C3BC1245DA702B434B9_at_lnewton.leeds.lfs.co.uk...
> Hi Peter,
>
> if you know the commands to shut down the database, then why not build
> them into your own bat file preceeded by the sqlplus session you want to
> run, for example :
>
> sqlplus /nolog @coldbackup.sql
> oradim -shutdown ...........
>
> or, have I missed something in the question here ?
>
> Cheers,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
>
> -----Original Message-----
> From: Peter Laursen [mailto:ptl_at_edbgruppen.dk]
> Posted At: Thursday, September 26, 2002 8:26 AM
> Posted To: server
> Conversation: ORASHUT.bat on 8i ?
> Subject: 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.
>
>
Received on Thu Sep 26 2002 - 07:25:34 CDT