Crash Recovery Vs Instance Recovery
When the instance suddenly fail due to power outage or issuing shut abort, the instance requires recovery during next startup. Oracle will perform crash recovery up on restarting the database.
Crash Recovery involves two steps Cache recovery and transaction recovery.
Cache Recovery (Roll Forward) : The committed and Uncommitted data from the online redolog files are applied to the datafiles.
Transaction Recovery (Roll Back): The uncommitted data are rolled back from the datafiles.
In an RAC environment, one of the surviving instance performs the crash recovery of failed instance. This is known as instance recovery. In a single instance database, crash recovery and instance recovery are synonymous.
Thanks
Monday, January 5, 2009
Subscribe to:
Post Comments (Atom)
1 comment:
clear cut explanation.. thank you..
Post a Comment