GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Backup and Recovery
Go To First  |  Previous Question  |  Next Question 
 Backup and Recovery  |  Question 8 of 42    Print  
144. What is On-line Redo Log?
The On-line Redo Log is a set of tow or more on-line redo files that record all committed  changes  made  to  the  database. Whenever a transaction is committed,  the  corresponding  redo entries temporarily stores in redo log buffers  of  the  SGA  are  written  to  an  on-line  redo  log file by the background  process  LGWR.  The on-line redo log files are used in cyclical fashion.



  
Total Answers and Comments: 5 Last Update: September 11, 2009   
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: samala
 

Redo logs records all the changes to the database  whether commited or uncommited. How does it know whether you are committing or rolling back till you commit it. Oracle always thinks positively that everything is going to be commited and writes to the log and when it is rolled back, it rolls back from the rollback segment otherwise those segments will be used for another transactions. Please correct me if iam wrong.


Thanks

Naveen samala



Above answer was rated as good by the following members:
deepikadba, majidwgl, ymcalr
October 13, 2005 15:01:55   #1  
sandeep vig        

RE: 144. What is On-line Redo Log?
The online redolog is a set of minimum two filegroups which has minimum one member and oracle uses it to record all the changes made to the database whether it is commited or not commited.oracle uses it to perform recovery after database crash.
 
Is this answer useful? Yes | No
February 10, 2006 19:58:47   #2  
venkat        

RE: 144. What is On-line Redo Log?
all un-commited transactions are stored in the redo logs
 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
August 02, 2007 05:18:44   #3  
diliph Member Since: August 2007   Contribution: 1    

What is On-line Redo Log?
Online Redo Log files are those which contain the information that changed the datafile it contains both the commited and uncommited data aswell. These files are needed for recovery.
 
Is this answer useful? Yes | No
September 15, 2007 05:28:30   #4  
samala        

RE: 144. What is On-line Redo Log?

Redo logs records all the changes to the database whether commited or uncommited. How does it know whether you are committing or rolling back till you commit it. Oracle always thinks positively that everything is going to be commited and writes to the log and when it is rolled back it rolls back from the rollback segment otherwise those segments will be used for another transactions. Please correct me if iam wrong.


Thanks

Naveen samala


 
Is this answer useful? Yes | NoAnswer is useful 3   Answer is not useful 0Overall Rating: +3    
September 09, 2009 11:00:33   #5  
oracleofdelphi Member Since: September 2009   Contribution: 6    

RE: 144. What is On-line Redo Log?
Online redologs name is used since archivelogs are called offline redologs. Online redologs can be in three states current to which lWr is currently writing transaction changes then this current becomes active after it gets filled and logswitch/ckpt happens then active becomes inactive only after its contents are syncronized with corresponding datafiles and undo files after this step it becomes inactive and it can go to current state only from inactive mode since this is a cycle its called cyclic buffer.
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape