rohitmisri

 Profile Answers by rohitmisri 

• Jun 17th, 2010

 

Hi,

When there is a any power outage happens and your database gets shutdown abnormally  at that time SMON process gets innitiated by the Oracle server and which works to protect instace to mantain all the components of a sga.

ssrkesh

 Profile Answers by ssrkesh 

• Oct 6th, 2010

 

During startup smon will look for SCN match in datafile and controlfile if it is not found in datafile then it performs recovery from logfiles.

zahed.mohammed

 Profile Answers by zahed.mohammed 

• Feb 15th, 2011

 

For committed data - Recovery can be perform from Online Redolog Files
For uncommitted data - From Undo Segment.

tutai4you

 Profile Answers by tutai4you 

• Dec 16th, 2011

 

When the Oracle instance fails. The SMON process performs instance recovery at startup using the online redo log files.

Nagaraj OCP

• Dec 27th, 2011

 

When shutdown abort happens, oracle server gets crashed. To recover from the crash, SMON will check the online Redo data files and last SCN no in the Redo log files and SCN number in the undo tablespace are same.

If yes, it performs recovery from redo log files else it rollback the values from undo tablespace.

ranjithsv18

• Oct 2nd, 2013

 

When hardware failure, software failue and shutdown abnormally happen...
SMON taking care of Instance failure, coalesce failure space and deallocating temp segment
start to recover instance Roll fwd with help of redologfiles for commited transaction and roll backward upto uncommited

transaction with help of undotablespace.
coalesce failure space: De-fragmenting every 3 sec
deallocating temp segment: Sorting purpose