Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Shutdown Oracle on NT Server

Re: Shutdown Oracle on NT Server

From: Joe Brown <joebrownNO_SPAM_me_very_MUCH_at_leading.net>
Date: Mon, 05 Oct 1998 15:20:50 GMT
Message-ID: <3618dd87.244832740@news.leading.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US