GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Concepts and Architecture
Go To First  |  Previous Question  |  Next Question 
 Concepts and Architecture  |  Question 50 of 74    Print  

What is the use of Control File ?

When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.




  
Total Answers and Comments: 3 Last Update: October 16, 2007   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
January 04, 2006 03:22:45   #1  
cmanne Member Since: January 2006   Contribution: 49    

RE: What is the use of Control File ?
Controlfile contains the information about the database like names and locations of datafiles name of the database database creation timestamp and apart from this the SCN are also reported into control during the database operation. Especially during the database startup the controlfile is used to gather the information about the database and while opening the database the information in the controlfile is validated to check for the consistency of the database.
 
Is this answer useful? Yes | No
January 04, 2006 06:19:19   #2  
Lalit Vasuja        

RE: What is the use of Control File ?
control file contain the physical structure of database.it also contain the current log sequence number.when database mount ->open then oracle server check the consistency of the database through the control fie.
 
Is this answer useful? Yes | No
October 16, 2007 00:12:18   #3  
Mohammed Abdul Afroze        

RE: What is the use of Control File ?

Uses of a Controlfile:

1.It is used to identify the names and locations of datafiles redologfiles.
2.Redo History is recorded during log switches.
3.Checkpoint information is recorded at ckpts are made.
4.Timestamp of database creation.
5.Database information is recorded when the database is created.


 
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