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.