Register Login

Difference between Oracle Mount, No Mount and Open Stage

Updated May 18, 2018

The differences in the 3 startup stages for oracle db are as below:

No Mount Stage:

When DB is in the nomount stage, oracle first opens and reads the initialization parameter file "init.ora" for the DB configuration which includes various parameters required for initialization. Based on the parameters, the memory areas in database instance are allocated and db background processes are started. The instance then starts.

Mount Stage:

When DB is in this stage, it opens and reads the control file which contains the physical structure of db  like the database datafiles etc.. It determines the location of the datafiles and the database is ready to be opened.

Open Stage

When DB is in this stage, it opens the database, it tries to access all of the datafiles associated with the database. Once it has accessed the database datafiles, it makes sure that all of the database datafiles are consistent.
After that DB is into normal operations state.


Comments

  • 24 Dec 2010 7:06 am Guest
    Hello,

    Could you please answer my following doubt?

    If i have to move redo logs and contolfiles .. is it to be done in the same way as the datafile movements?
    In which state is the control files changed in init.ora file -- shut down or no mount ??
  • 25 Dec 2010 12:30 pm kiran
    You want to move offline redo logs or online redo logs?
  • 31 Jan 2013 11:33 am Guest
    shutdown phase

×