| mount [message #61787] |
Thu, 27 May 2004 11:13  |
raviranjan
Messages: 41
Registered: April 2004
|
Member |
|
|
hi
i want to know abt mount.and no mount
what happen if i mount database .
plz describe it.
what's happen when i mount the data base
plz..........
|
|
|
|
| Re: mount [message #61789 is a reply to message #61787] |
Thu, 27 May 2004 18:13  |
Sujit Sarkar
Messages: 40
Registered: September 2003
|
Member |
|
|
Hi Ravi,
when your database is in mount stage the controlfile gets opened (i,e controlfile is loaded & opened in memory).
in no mount stage only the instance is created but the controlfile & database are not opened.
when you write STARTUP command
the sequence of events which are performed are:
1. instance created -- only sga & background processes are started
2. database mounted -- controlfile is opened & read
3. database opened -- all the datafiles whose references are checked from the controlfile are opened in read/write mode.
thanx & rgrds
Sujit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
