| DBA General Question [message #53426] |
Thu, 19 September 2002 03:06  |
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
|
|
|
|
| Some basic info [message #53592 is a reply to message #53426] |
Tue, 01 October 2002 01:48  |
jayharper
Messages: 4
Registered: September 2002
|
Junior Member |
|
|
Starting an instance:
1) reading the parameter file initSID.ora
2) allocating the SGA
3) starting the background processes
4) opening the ALERT file and the trace files
5) mounting the database:
* associating a database with a previously started instance
* locating and opening the control files specified in the parameter file
* reading the control files to obtain the names and status of the data files and redo logs
6) opening the database
* opening the online data files
* opening the online redo log files
7) instance recovery occurs when theinstance cannot continue to work
* roll forward online redo logs
* opening the database
* rolling back uncommitted transactions by SMON
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
