rajat dey

• Feb 21st, 2006

 

hi,It is a part of oracle physical structure of the database which is recording all the commited and uncommited transaction of the database and monitering by backgruond process called LGRWRregrdsrajat dey

nagabhushan reddy

 Profile Answers by nagabhushan reddy 

• Mar 7th, 2006

 

redolog file which having latest changes made to database.

and it can be used for recovery of the database

sampath kumar

• May 17th, 2006

 

red log file store the changes in the data file.it mainly used for recovery purpose..

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• May 21st, 2008

 

Oracle maintains logs of all transactions against the databse. These transactions are recorded in files called Online Redo log files.

These logs are used to recover the database's transaction in their proper order in the evnt of database crash. The redo log information is stored in Redo log file which is external to the datafiles

Each database have two or more online redo log files. oracle writes tedo log file in cyclic order after the first log is filled , it writes to the second log files, until that one is filled. whn all of the online redo log file have been filled it move to the first online redo log file and start overwriting the transaction record

Note : if the Databse is in ARCHIVE log mode then database will make the copy of the redo log file before overwriting the contents of the log file..
These ARCHIEVED redo log file can then be used to recover any part of the database to any point of time.