Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORASHUT.bat on 8i ?
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.
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 - 03:50:00 CDT