Re: Shutdown Oracle on NT Server

jerome_villafruela_at_yoni.fr wrote:

> In article <6v9ja6$g2d$1_at_nnrp1.dejanews.com>,
>
> You may use the oradim73 program (oradim72 if you're running Oracle 7.2) :

oradim80 for Oracle 8.0. Go figure...

> To shut down the db :
> c:\orant\bin\oradim73.exe -shutdown -sid <SID> -usrpwd <Instance Password> -
> shuttype srvc,inst -pfile c:\orant\database\init<SID>.ora

Woah. That's a lot of parameters for shutdown. -pfile has no meaning for shutdown.

oradim?? -help <- difficult to use because the way it's implemented.

oradim?? -shutdown -sid ORCL -usrpwd ORACLE -shuttype INST -shutmode i

The -shutmode i (immediate) is important if there is any possibility that a user may still be connected to the database. When shutdown is issued if a user is still connected shutdown will wait for that user to log off unless you specify i (immediate) or a (abort).

I don't like this method, because when you startup after an immediate shutdown, you're supposed to issue a startup recover. I see no option for recovery via ORADIM??.

BTW: I omitted srvc (service) in the shuttype. You may want to shutdown the service as well, to free adittional memory for you backup process...
-shuttype SRVC,INST

> To start the database after the backup :
> c:\orant\bin\oradim73.exe -startup -sid <SID> -usrpwd <Instance Password> -
> starttype srvc,inst -pfile c:\orant\database\init<SID>.ora

--
joebrown
@leading.net Received on Mon Oct 05 1998 - 10:20:50 CDT