When I start Oracle Server what happens? [message #53437] |
Thu, 19 September 2002 11:45 |
Allathur
Messages: 3 Registered: September 2002
|
Junior Member |
|
|
Hi,
I need to about "When I start Oracle Server what happens?" Like when instance is started SGA is allocated, background processes are started, alert file is ready and initialization parameters are read.
Thanks in advance
Allathur
|
|
|
Re: When I start Oracle Server what happens? [message #53484 is a reply to message #53437] |
Mon, 23 September 2002 13:51 |
Trifon Anguelov
Messages: 514 Registered: June 2002
|
Senior Member |
|
|
You got is right so far.
What you issue from the svrmgrl : startup Oracle goes through the following phases:
1. nomount - init.ora file is read and the SGA is allocated. the location of the control files is read, and they are checked if could be opened.
2. mount - the control files are read, the location of the datafiles is read, the datafiles are checked against the list in the control file. the background proceses are started.
3. open - the headers of the datafiles are checked against the information in the control files, the same for the redo log files, the headers are then updated and database is open.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|