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.

  • Interview Candidate
  • 3
  • 8755

Showing Answers 1 - 3 of 3 Answers

cmanne

  • Jan 4th, 2006
 

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.

  Was this answer useful?  Yes

Lalit Vasuja

  • Jan 4th, 2006
 

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.

  Was this answer useful?  Yes

Mohammed Abdul Afroze

  • Oct 16th, 2007
 

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions