Friday, May 22, 2009

Oracle Concepts:All about Redo Log files

Basically intended for recovery during a media failure.
Every Oracle database has a set of two or more redo log files. Suppose a media failure prevents the data in the buffer to be wriitern in to the datafile, we will always have an option to retrieve data from the redo log file.
Redo log file basically stores the modification done to data.
To prevent any failure involving redo log file itself , oracle offers something known as multiplexed redo log where in two or more copies of the redo log file are maintained in two different disks.
Recovering data from a redolog file during a recovery operation is known as rolling forward

No comments:

Post a Comment

Which is the most stable database?