What is the use of control file

Showing Answers 1 - 10 of 10 Answers

Deepak katyal

  • Jul 7th, 2005

Control file is binary file which is having all the information realted to database. db_name, maxlogfiles, maxdatafiles, tablespaces information. Without this u cannot open your database. Init.ora parameter file showing the location of the controlfile.

  Was this answer useful?  Yes

nagabhushan reddy

  • Feb 8th, 2006

control file is a binary file which contains db_name,dbcreated,checkpoint information,datafiles and logfiles.

  Was this answer useful?  Yes


  • Jul 29th, 2006

Control file contains the names and locations of data files and redolog files, database creation timestamp along with the SCN information through which the controlfile could find the inconsistency.

  Was this answer useful?  Yes


  • Nov 21st, 2006

USE of Control File:

Control file contains control information used to - Start an instance such as location of datafile and redo log files. These file maintain internal consistency and guide recovery operation.

Control file is stored in .ctl format and in binary format

  Was this answer useful?  Yes


  • Jun 8th, 2012

Control file contain metadata of the database.And also containing as follows,
Name of the database & when was database created.
Name & location of datafiles,redolog files.
Backup information(RMAN).
SCN information stored into it.

  Was this answer useful?  Yes


  • Jul 19th, 2012

control file is used to startup the database from nomount stage to mount stage. Firstly, when the database is started it looks for the path of control file in the parameter file and the database is now in the nomount stage. Now the database looks for the control files to startup the database.


  • Oct 16th, 2013

Control file is back bone of database. Contorl file having all information about redo log files and log files.

  Was this answer useful?  Yes

pavan dba

  • Jun 12th, 2014

control file contains:
The database name
Names and locations of associated datafiles and redo log files
The time stamp of the database creation
The current log sequence number
Checkpoint information

  Was this answer useful?  Yes

syed fahad

  • Sep 13th, 2014

Control file which stores all information of database like
1)Name and location of datafile and redo logfile
2)Scn number information
3)Db_name information
4Checkpoint information

  Was this answer useful?  Yes

Vla Su

  • Feb 2nd, 2015

Dump control file into text what is the usage

  1. ALTER session SET events immediate trace name controlf level 3;

  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