Solved

startupmount

Posted on 2013-11-15
5
214 Views
Last Modified: 2013-11-17
What will happen at startup mount
0
Comment
Question by:dev_dba
  • 2
  • 2
5 Comments
 
LVL 22

Expert Comment

by:Steve Wales
ID: 39652476
Refer to the Documentation:
http://docs.oracle.com/cd/B28359_01/server.111/b28318/startup.htm#CNCPT1295

At startup mount the control files are opened the names of the data files and redo log files are read.

These files are not opened until the database is opened.
0
 

Author Comment

by:dev_dba
ID: 39652518
When will parameter file read...it won't be read at startup mount.
0
 
LVL 15

Expert Comment

by:Franck Pachot
ID: 39652531
parameter file is read before, at startup nomount.
0
 
LVL 22

Accepted Solution

by:
Steve Wales earned 500 total points
ID: 39652558
There are three stages in the startup of a database.

At nomount, the parameter file is read, which identifies where to find the controlfiles, how to allocate memory etc.

At mount, as mentioned, the controlfiles are read and the data/redo log files are identified.

At open, the data / redo log files are opened.
0
 

Author Closing Comment

by:dev_dba
ID: 39655472
no mount -------------init.ora
mount        -------------.ctl
open       ------------------ .dbf,ctl,.log
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question