Redo log is a mandatory componed in database(oracle) and it will record all the changes made to the database whether it is committed or not committed.
U need to have redo logs if u want to recover database to the point of failure and database has to run in archivelog mode.


Thanks and Regards

GowdA....
CTS - CSI
Vnet -- 42275
P & T -- 2275

"Our life is what our thoughts made it"


-----Original Message-----
From: MKTN [mailto:tharanga.[Email Address Removed]
Sent: Friday, August 29, 2003 8:20 AM
To: LazyDBA.com Discussion
Subject: use of Redo log files



Hello Experts,
Can anyone explain me the use of REDO LOG files in Oracle database.
How does it interact with database and datafiles in the database. Which data are written there?
Does REDO LOGs are essential to recover a databse in case of failiure(crash)

Regards,
MK

This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.

Visit us at http://www.cognizant.com
Oracle LazyDBA home page