| Kaiz |
Posted: Dec 12, 2007 08:56:30 AM |
Total Post: 104
Joined: Sep, 2007
|
Dear Friends,
Can any one please explain the exact meaning of-
Oracle server checks the consistency of the database at the time of command Startup...
With Regards.. |
|
|
 Murtuja |
| Posted: Dec 12, 2007 09:29:20 AM |  |
|
Total Post: 814
Joined: Jan, 2006
|
When checkpoint occurs and SCN is recorded in both controlfile and datafile's header.If it is not same in both that means database is inconsitent
|
|
|
|
|
| vikhardba |
| Posted: Dec 12, 2007 12:54:46 PM | |
|
Total Post: 86
Joined: Apr, 2007
|
I agree with Murtuza. And SMON is responsible for database consistency.
|
|
|
|
|
| Murtuja |
| Posted: Dec 12, 2007 11:32:30 PM | |
|
Total Post: 814
Joined: Jan, 2006
|
Kaiz,
Read this article
Understanding the SCN
By sandeep makol
http://www.dbapool.com/articles/1029200701.html
|
|
|
|
|
| Kaiz |
| Posted: Dec 13, 2007 09:34:42 AM | |
|
Total Post: 104
Joined: Sep, 2007
|
Thanks...
I will read the article ....
With Regards..
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
