Shutdown Database

Shutdown Database

Shutdown Database :- To shutdown Oracle database we need to use "shutdown" command

Ways of shutdown database :- There are following three ways to shutdown database

1) shutdown transnational
2) shutdown abort (recovery will ask at the time of startup)
3) shutdown immediate

1) shutdown transnational  :- It allow to all connected session to complete their session. After complete session, it will not allow to execute any query as well as it will not allow new session as well. 



2) shutdown abort :- This will not allow any query to any session as well as no guarantee to save all sessions transaction.




3) shutdown immediate :- It will not allow any new query to any session but guarantee to save all session transactions.