startup Database

Startup Database

Startup :- To start Oracle services we use "startup" command

Startup Stages :- There are 3 stages of startup 

Nomount=>Mount=>Open

1) startup nomount (Only parameter file will be open)



Note:- After "startup nomount" only "alter database command" is working to change the database stage. Also we can not change the stage from nomount to open , first you have to change stage from nomount to mount then you can change mount to open.

2) startup mount (parameter and control file will be open)



Note :-After mount stage we can open database by "alter database" command.

 3) startup /startup open (database will be open)

 

This command open the database.

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.