Home » RDBMS Server » Server Administration » Database Mounting
Database Mounting [message #57681] Mon, 30 June 2003 03:11 Go to next message
JRRAO
Messages: 9
Registered: June 2003
Junior Member
Hi,
I m a beginner in Oracle.
What is the exact meaning of mounting the database?

TIA,
JRRAO
Re: Database Mounting [message #57682 is a reply to message #57681] Mon, 30 June 2003 03:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
first an instance is created 

Instance is a combination of sga and background processes. This instance is instantiated by reading the initsid.ora.
If there is any errors u will the message ,error in initsid.ora or init parameters

Next the database is mounted.

the control file is read (which is identified by
the initsid.ora)
By this oracle does the integrity check. 
control is Most important file for oracle to function.
If there is any errors you will get an error stating in opening the control file or mounting the
database

Next the database is opened.

if all the three previous checks are OK, the oracle makes the datafiles and logfiles ( identified by the controlfile in previous step) available to public
   
                              

                                     --------
                                     | open datafiles and logfiles (open the database)
                                     
                                     |  
                              -------    
                              | open the controlfile (mount database)
                              
                              
                      --------
                    identify the initsid.ora (create instance)

Re: Database Mounting [message #57683 is a reply to message #57682] Mon, 30 June 2003 04:03 Go to previous messageGo to next message
sachin kumar gupta
Messages: 157
Registered: March 2003
Senior Member
Thanx a lot Mahesh!!!

Sachin
Re: Database Mounting [message #57689 is a reply to message #57682] Tue, 01 July 2003 01:01 Go to previous messageGo to next message
sachin kumar gupta
Messages: 157
Registered: March 2003
Senior Member
One thing more Mahesh!!
While mounting the database what kind of integrity checks are made by Oracle while reading the control files.

TIA,
Sachin
Re: Database Mounting [message #57706 is a reply to message #57689] Tue, 01 July 2003 05:57 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
the control file identifies the datafiles and logfiles.
It has all the timestamp information , header information and other internals.
Using this information, it identifies the datafiles.
Everytime you startup and shutdown oracle,
the currrent state of datafiles are recorded in controlfile.
Previous Topic: Maximum column name length??
Next Topic: What could be the reason?
Goto Forum:
  


Current Time: Fri Sep 20 11:32:44 CDT 2024