Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

startupmount

Posted on 2013-11-15
5
Medium Priority
?
220 Views
Last Modified: 2013-11-17
What will happen at startup mount
0
Comment
Question by:dev_dba
  • 2
  • 2
5 Comments
 
LVL 23

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 23

Accepted Solution

by:
Steve Wales earned 2000 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

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

916 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