Re: Cold back: net stop OracleServiceSID

From: Laurent Pichonnet <Laurent.Pichonnet_at_jcdecaux.fr>
Date: Thu, 2 Sep 1999 18:09:40 +0200
Message-ID: <7qm7d8$cr8$1@minus.oleane.net>

Peter Laursen a écrit dans le message <01bef557$01fd4d10$2c289a0a_at_apollo>...

>Questions:
>Is net stop ... the same as a shutdown abort?

yes (at next open, Oracle do a recovery)

>Assume users are logged in, but have no active transactions, when the db
>shuts down, will that harm the database?

yes for SHUTDOWN NORMAL

>To do recovey I simple owerwrite datafiles and controlfiles (and redo's?)
>from last nights backup and start the database again?

For simple recovery procedure, the redo's file must be overwrited with the other database files.

>Could I do a better scripts, ie shutting down more gracefully, without
>revealing passwords?

You must set the following registry key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORA_SHUTDOWN to "TRUE".

Then , when you stop the service "OracleServiceSID" through NET command (or Control Panel applet) the script ORASHUT.BAT located in %ORACLE_HOME%\DATABASE is automatically invoked by the ORACLE80.EXE process and properly close the database (SHUTDOWN IMMEDIATE with SVRMGR30).

Laurent Pichonnet
DBA. Received on Thu Sep 02 1999 - 11:09:40 CDT