Home » Database Administration » Difference Between Oracle Mount, No Mount and Open Stage

Difference Between Oracle Mount, No Mount and Open Stage

RSS Link

  • An error has occurred; the feed is probably down. Try again later.

Blog Stats

  • 690,237 hits


Categories

Advertisements

Just for refreshing my memory and yours

he differences in the 3 startup stages for oracle db are as below.

NoMount 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.

Advertisements

2 Comments

  1. tgjhijp says:

    good one

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

My twitter post @devratt

May 2010
M T W T F S S
« Apr   Jun »
 12
3456789
10111213141516
17181920212223
24252627282930
31  

Popularity


PageRank

Bookmark and Share

Top Clicks

  • None
%d bloggers like this: