Startup dan Shutdown Instance in Oracle

Startup dan Shutdown Instance in Oracle

Administration (activity) that we can do in the instance is startup, shutdown, and alter. In general, the startup process is as follows:

1. Database off (shutdown)
Background process has not gone up. Memory has not been allocated
2.  Nomount
Backgroung process is increased. Memory allocated
3. Mount
Instance reading the control file. Control file contains the configuration database. Instance has not read the data file.
4 Open
Instance already read the data file (header). Database readily accessible

 Command Startup

startup
startup open
startup nomount
startup mount
startup force


Command "startup" without argument, by default is "startup open"
Command "startup force" is just the same with "shutdown abort" and then "startup"

 Command Shutdown

shutdown normal
shutdown transactional
shutdown immediate
shutdown abort

Here is a comparison of the shutdown process normal (N), transactional (T), immediate (I), and abort (A):

Proses	Shutdown
	A	I	T	N
Allowed new connection	No	No	No	No
wait until all sessions disconnect	No	No	No	Yes
wait until all transactions are complete	No	No	Yes	Yes
perform checkpoint and close file	No	Yes	Yes	Yes

reference : http://rohmad.net/2008/05/14/startup-dan-shutdown-instance/