Concepts and Architecture - What is a Redo Log ?

GeekInterview.com > Interview Questions > Oracle > Concepts and Architecture

Go To First | Previous Question | Next Question

Concepts and Architecture | Question 46 of 74

What is a Redo Log ?

The set of Redo Log files for a database is collectively known as the database's redo log.

Total Answers and Comments: 4

Last Update: May 21, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: satyam_Ora

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.

Above answer was rated as good by the following members:
c.nagaraju, bhatnagar_neeraj

February 21, 2006 03:52:33

rajat dey

RE: What is a Redo Log ?

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

Is this answer useful? Yes | No

March 07, 2006 06:17:14

nagabhushan reddy

Member Since: December 2005 Contribution: 4

RE: What is a Redo Log ?

redolog file which having latest changes made to database.

and it can be used for recovery of the database

Is this answer useful? Yes | No

May 17, 2006 02:14:34

sampath kumar

RE: What is a Redo Log ?

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

Is this answer useful? Yes | No

0 1

Overall Rating: -1

May 21, 2008 00:27:36

satyam_Ora

Member Since: July 2007 Contribution: 29

RE: What is a Redo Log ?

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.

Is this answer useful? Yes | No

2 0

Overall Rating: +2

Go To Top

User Name		Remember Me?
Password

Question Bank