When you shut down an Oracle database, it is best to do the following:
1. Shutdown immediate - will gracefully disconnect running sessions.
2. Startup restrict - starts the database in a mode such that no users can connect and no internal management jobs are started by Oracle.
3. Shutdown - is a clean shut down. Doing it this way minimize the time it takes to restart the database when it is ready to be put back in normal operation.
Have a question you would like to ask our expert?
