Monday, November 9, 2009

Stages of Oracle Startup and Shutdown

Instance Startup, DB Mount, DB Open
(DB Close, DB Unmount, Instance Shutdown)

startup
startup restrict
startup nomount
startup mount
startup read only

startup force restrict
startup force mount
startup force nomount

shutdown (shutdown normal)
shutdown immediate
shutdown abort
shutdown transactional

e.g.

$>sqlplus / as sysdba
SQL> startup;


------

$>sqlplus / as sysdba
SQL>startup nomount;


------

$>sqlplus / as sysdba
SQL>starup mount;


------

$>sqlplus / as sysdba
SQL>shutdown immediate;


-------

-Suresh

No comments:

Post a Comment