Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Instance recovery by SMON

happy10319Feb 1 2010 — edited Feb 1 2010
Hi,

are you agree with the followings :
Your database is running in the ARCHIVELOG mode. After an instance crash, you start up the database by issuing the STARTUP
command. Instance recovery is initiated by the SMON background process.

The information used for instance recovery will be derived from the control file.
The uncommitted changes are rolled back using information in the undo segments.
The committed and uncommitted changes stored in the online redo log are applied to the
affected data blocks.
Many thanks.
This post has been answered by Girish Sharma on Feb 1 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2010
Added on Feb 1 2010
8 comments
4,799 views