| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Shutdown Oracle on NT Server
On Mon, 05 Oct 1998 15:20:50 GMT,
joebrownNO_SPAM_me_very_MUCH_at_leading.net (Joe Brown) wrote:
>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??.
This last paragraph is wrong. After shutdown immediate the database is closed in a *totaly consistent* state, so there is no need for any recovery after starting it up again - no instance recovery, no media recovery, no nothing.
Of course, if you shutted the database down with the abort option, then at the next startup instance recovery must be performed. But it will be performed automaticaly by the database and hence there is no need to pass any special "recovery" parameter to the oradim.
>
>--
>joebrown
>@leading.net
Regards,
--
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)
 |
 |